Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “oblong” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

317 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
oblong93538(None) 
oblongs1033531oblongs
oolong738071oolong
along65419492_along
belong93411042belong
blog75723822_blo_g
blond85618372_blond
bong75633412_b_ong
doblon938012doblon_
doblons1037042doblons
flong95815682_flong
kalong1177702kalong
klong105310402_klong
long56933342__long
oblongly1442482oblongly
ogling83211882ogling
oiling74925312oiling
oolongs845952oolongs
orlon5415002orlon_
orlons6411012orlons
abalone938903abalone
ablings1038743ablings
ablins8316193ablins
abloom1039783abloom
aboon74918703aboon_
abying124410413abying
agelong934983agelong
ailing74331013ailing
alang66023513_alang
allonge837023allonge
alone55732963_alone
ambling121411793ambling
among85813303_among
azlon144312873azlon_
azlons154110423azlons
baling94829693baling
bang74837013_b_ang
barong96015823barong
being84920503_being
belon73924113belon_
belongs10408223belongs
belons84119413belons
bhang115512923_bhang
biltong1034683biltong
biog76122323_bio_g
biont7727163_biont
bland85320453_bland
blank115418553_blank
blend85317453_blend
blent76230953_blent
blin67228173_blin_
blind86319323_blind
blini75519273_blini
blink115720143_blink
bloat75229923_bloat
blob86027093_blo_b
blobs95620033_blobs
bloc85023273_blo_c
block134917843_block
blocs95219653_blocs
blogs85319233_blogs
bloke114316633_bloke
blonde94813293_blonde
blonds95213343_blonds
blood85319523_blood
bloom95918973_bloom
bloop96116153_bloop
blot65842323_blo_t
blots75626173_blots
blow95827193_blo_w
blowing133813053_blowing
blown105716673_blown
blows105423833_blows
blowy134315323_blowy
bluing94914483_bluing
blunge94311483_blunge
blunt75525023_blunt
bobbing113113193bobbing
bobbling12238643bobbling
boding104320063boding
bog67852413_b_o_g
boiling103819673boiling
boing84725553_boing
bolling103820883bolling
bolo65535953bolo__
bologna1044253bologna
boloney1247763boloney
bolos75531373bolo_s
bolson8410683bolson_
bolsons969483bolsons
bolting104416763bolting
bond75334363_b_ond
bone65949323_b_one
bongo85720943_b_ongo
bongs87828423_b_ongs
boning94223293boning
bonk105531713_b_onk
bony96732083_b_ony
booing94521643booing
boon67142173_boon_
boons75031913_boons
boring94724873boring
boron76727143boron_
borons85520543borons
boson76019733boson_
bosons85016653bosons
bowing124723063bowing
bowling133916493bowling
boxing163915153boxing
bring85528503_bring
bronc91714343_bronc
brung84613913_brung
bung75730633_b_ung
cabling124017553cabling
clang86019313_clang
cling86424673_cling
clog76123243_clo_g
clon66232483_clon_
clone75728163_clone
clonk114417443_clonk
clons75228133_clons
clung86013603_clung
coaling103722823coaling
cobbling15248803cobbling
codling114418953codling
coiling103723453coiling
colog86619933colo_g
colon78630193colon_
colone85425003colone
coloni85619203coloni
colons86028683colons
colony115417273colony
cooling103422573cooling
cowling134017423cowling
daylong1233973daylong
doblones1136763doblones
dobson936593dobson_
dobsons1036203dobsons
doling84923133doling
dolling93817373dolling
dong66031653__dong
doubling1238153doubling
dugong934373dugong
ebbing1137073ebbing
ebon66821103eb_on_
ebons74316093eb_ons
ebony104511513eb_ony
endlong934823endlong
eobiont959943eobiont
erelong835593erelong
fabling133413623fabling
felon84619293felon_
felons93615763felons
felony123710323felony
filing103823763filing
fling97023513_fling
flog85523893_flo_g
flongs105010493_flongs
flung95114583_flung
foaling113515843foaling
fobbing153410273fobbing
foiling113317653foiling
fooling113117373fooling
fouling113315373fouling
fowling143713113fowling
furlong11295413furlong
gabling113514543gabling
glogg837353_glogg
goaling93515333goaling
gobang10376703gob_ang
gobbing132910703gobbing
gobbling14257533gobbling
goblin939503goblin_
goblins1039243goblins
gobony1236913gob_ony
godling103513403godling
gong66827193__gong
gosling93312403gosling
haling104229783haling
haloing113814133haloing
halon86124863halon_
halons95720713halons
hobbing152811123hobbing
hobbling16227583hobbling
hoboing13309453hoboing
holing104025073holing
holloing12148823holloing
hong85833953__hong
hourlong1242733hourlong
howling143413163howling
idling8912883idling
isling71213883isling
jobbing19279013jobbing
kalongs1255443kalongs
klongs11436603_klongs
lang56637393__lang
legong836963legong
ling57447963__ling
lobbing123110913lobbing
log46252683__lo_g
lolling83415783lolling
lone45849133__lone
longe66626463__longe
longs65527063__longs
lung55732493__lung
melon73922083melon_
melons84117713melons
mobbing14299703mobbing
moiling103417663moiling
muling93519883muling
nobbling13228273nobbling
nylon82910513nylon_
nylons9267973nylons
oaring74225303oaring
obconic1346353obconic
obeying1336543obeying
oblast8613663oblast
oblate82214743oblate
oblige937653oblige
obliging1236103obliging
obloquy2141873obloquy
oboe66822943ob_o_e
oboes75717713ob_oes
obol65220613ob_o_l
obole75917143ob_ole
oboles83815833oboles
oboli73712873ob_oli
obols73715863ob_ols
obolus8378813obolus
obtund945583obtund
ochone11311293ochone
odeon6411483odeon_
odeons739023odeons
offing13368643offing
ohing96018813o_hing
olingo736933o_lingo
ology94113113o_logy
ongoing938793ongoing
onion54320973onion_
onions64016433onions
oniony9369703oniony
online6315843online
onload7268633onload
oohing104412933oohing
oology103210253oology
oozing163812203oozing
oping86322413o_ping
opting94514403opting
orang65119943o_rang
orbing93312363orbing
orgone71110913orgone
orlop7410903orlo_p
orlops847303orlops
ourang73311063ourang
outing74128153outing
overlong1238123overlong
owing96222723o_wing
owning104110333owning
oxblood1743603oxblood
ozone14310613o_zone
paling93530133paling
pelon74423213pelon_
piling95025593piling
plonk114613983_plonk
poblano1145093poblano
poling93526503poling
polling102920383polling
pong76231143__pong
pooling103219093pooling
prolong10319633prolong
prong85218113_prong
puling93621403puling
pylon103614003pylon_
pylons113011243pylons
riling74227973riling
robbing123313213robbing
robing93618003rob_ing
roiling83220453roiling
rolling83620413rolling
ruling73219553ruling
salon55228553salon_
salons63823693salons
sarong73914873sarong
sibling10814423sibling
siloing83215503siloing
slang66324023_slang
sling66028803_sling
slog56728273_slo_g
slung65117833_slung
sobbing127612883sobbing
soiling83422323soiling
soling74226823soling
soloing82813803soloing
solon55026133solon_
solons65120023solons
song55133673__song
strong74914883strong
tabling103216033tabling
talon55824113talon_
talons64019443talons
thong95014183_thong
throng10539973throng
tiling73426553tiling
toiling83219023toiling
toling73926123toling
tolling83418563tolling
tong56434363__tong
tooling82918313tooling
voling103918023voling
waling104525303waling
weblog1234223weblo_g
wiling103024293wiling
wobbling16246923wobbling
wrong94712323_wrong
wyling13368553wyling
yodling123610253yodling
yowling143610223yowling

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.376475242.0
2DLD Change Limit1127163174.92322895.8
3Display Results3173170.1102881.8
 (SQL Overall)1786913175.40933035.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.