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 “polos” with Change Limit: [1] [2]

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

265 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
polos7612991(None) 
bolos75531371bolos
kolos94921211kolos
nolos54423351nolos
poles75351001poles
polios84019721polios
polis74731161polis
polls74627721polls
polo66236631polo_
pols66044561pol_s
polys105718761polys
pomos95321581pomos
pools74427701pools
poos65949111po_os
solos54830791solos
apollos946792apollos
apolog938902apolog
apologs1038592apologs
bohos105618252bohos
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolo65535952bolo_
bolts76232112bolts
bolus79125542bolus
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
calos74431902calos
cholos114716852cholos
cocos95624692cocos
cohos105921852cohos
colas75436772colas
colds85726972colds
coles76055062coles
colog86619932colog
cologs96517352cologs
colon78630192colon
colons86028682colons
color76123742color
colors86622372colors
cols66553082col_s
colts76633292colts
cools75632632cools
coos67456492co_os
dodos75819392dodos
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolor67617962dolor
dolors75115312dolors
dols56943052dol_s
dolts65626312dolts
filos86125382filos
folds95221692folds
folios93915462folios
folks126017122folks
fools86824202fools
gobos86219382gobos
gogos77516522gogos
golds75421312golds
golfs95616102golfs
golosh1036462golosh
goos57644912go_os
halos85230252halos
helos84928062helos
hobos106321352hobos
holds94623242holds
holes84748652holes
holks124720562holks
hollos95320632hollos
holms105117802holms
hols76946292hol_s
holts85627912holts
homos105921782homos
joles125230832joles
jolts125018882jolts
kilos95021472kilos
kobos115616892kobos
kolas94822232kolas
kolo87026222kolo_
kotos95717702kotos
lilos55821872lilos
lobos75921842lobos
locos75822602locos
logos67225332logos
lolls512121732lolls
loos49051122lo_os
lotos54724632lotos
milos75428012milos
mojos145314462mojos
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
monos75930862monos
mools76027172mools
moos66051302mo_os
mozos165516332mozos
nolo46229312nolo_
nomos75919742nomos
olds55926572_olds
oleos55419682_oleos
oles46453472_oles
olios54520852_olios
onos46229002_onos
ovolos9257202ovolos
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
peles75738082peles
pelfs105016292pelfs
pelon74423212pelon
pelts76128812pelts
peplos101211542peplos
pepos96620082pepos
pesos77221622pesos
phlox1737332phlox
phonos114114792phonos
photos113316642photos
piles74742612piles
pilis75825202pilis
pills74130972pills
pilose84514242pilose
pilot77435062pilot
pilots84018872pilots
pilous84717752pilous
pilus75921062pilus
pisos76021062pisos
plod76723272p_lod
plods85719292plods
plop86625742p_lop
plops95920332plops
plot66141232p_lot
plots75025672plots
plow95923232p_low
plows105419902plows
ploy96123602p_loy
ploys105816592ploys
plus66324832p_lus
poboy121612222poboy
poboys1397312poboys
pocks135022962pocks
poco86826152poco_
pods76540152po_ds
poems95715552poems
poets76024442poets
poilus82210572poilus
pois66539042po_is
pokes116133012pokes
pol56449382pol__
polar75623452polar
polars84419352polars
pole65951302pol_e
poled84934842poled
poleis86018352poleis
poler74431792poler
polers84225642polers
polies84034582polies
polio75722552polio
polish114916722polish
polka11310412polka
polkas1239102polkas
poll66332132pol_l
poloist91016322poloist
poly96235152pol_y
polyol1138712polyol
polyols1238492polyols
polyp125611532polyp
polyps13479762polyps
pomelos11218132pomelos
pomes94833932pomes
pomo85828452pomo_
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
poo57757112po_o_
pood75934322po_od
poods85124752poods
poof95541662po_of
poofs105222792poofs
pooh96027382po_oh
poohs103915712poohs
pool65835952po_ol
poon67341262po_on
poons75430972poons
poop86532812po_op
poops94422412poops
poor65630222po_or
popes95933812popes
pops86340952po_ps
pores75849032pores
porks115124142porks
pornos85015252pornos
porns75527342porns
porose84818742porose
porous84419482porous
ports75934592ports
poses74642762poses
posts75228782posts
pothos114214692pothos
pots66452362po_ts
pottos84615872pottos
poufs105616062poufs
poults84613482poults
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
poyou102611522poyou
poyous112911622poyous
praos74923562praos
proles84627202proles
prolog94212972prolog
prologs103512132prologs
promos105116422promos
pros65742782p_ros
prosos85718552prosos
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
pylon103614002pylon
pylons113011242pylons
pyros105718292pyros
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rotos56027882rotos
silos56029432silos
soles55547922soles
solo45538942solo_
solon55026132solon
solons65120022solons
sols45448162sol_s
solus54726982solus
spools85115912spools
telos55424522telos
tholos94213002tholos
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tools55325242tools
topos75726392topos
toros54336192toros
toyos87519142toyos
voles86234042voles
volost9412642volost
volts85421292volts
wolds95420182wolds
wolfs116214162wolfs
wools84421462wools
woos76238802wo_os
yolks125412772yolks
zoos135828802zo_os

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002651.64332745.0
3Display Results2652650.0763486.8
 (SQL Overall)1786912651.81298615.3
 
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.