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 “polo” 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.

257 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
polo6623663(None) 
bolo65535951bolo
kolo87026221kolo
nolo46229311nolo
poco86826151poco
pol56449381pol_
pole65951301pole
polio75722551polio
poll66332131poll
polos76129911polos
pols66044561pols
poly96235151poly
pomo85828451pomo
poo57757111po_o
pool65835951pool
solo45538941solo
apollo837182apollo
apolog938902apolog
boho96923322boho
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolos75531372bolos
bolt66254172bolt
boo58163662bo_o
boyo96923842boyo
bozo156821412bozo
calo64936442calo
cholo105217972cholo
coco87330602coco
coho97524492coho
col59360352col_
cola66541392cola
cold77338772cold
cole66956112cole
colog86619932colog
colon78630192colon
color76123742color
cols66553082cols
colt67158242colt
coly96940532coly
coo59566362co_o
cool66940492cool
dodo66024912dodo
dojo126016142dojo
dol47150652dol_
dole56550002dole
doll56632492doll
dolor67617962dolor
dols56943052dols
dolt56649422dolt
filo76034282filo
fold86528942fold
folio83820882folio
folk116021542folk
fool75330592fool
gobo76126902gobo
gogo69722832gogo
gold65430162gold
golf85731182golf
goo47754772go_o
halo76437322halo
helo75332852helo
hobo97026082hobo
hold86235062hold
hole77553392hole
holk116027942holk
hollo84822162hollo
holm95628112holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
homo96126472homo
jole117233822jole
jolt116639122jolt
kilo86028662kilo
kobo107422102kobo
kola85124962kola
kolos94921212kolos
koto86323472koto
lilo46731562lilo
lo28053442__lo
lobo67229862lobo
loco67030742loco
logo57931762logo
loll46128382loll
loo38359822lo_o
milo65536102milo
mojo136917222mojo
mol56654592mol_
mola66035632mola
mold76034332mold
mole66251832mole
moll66735702moll
mols65948572mols
molt66356162molt
molto75619602molto
moly96031912moly
mono66036722mono
moo58460512mo_o
mool67533862mool
mozo157719742mozo
nolos54423352nolos
noo37154042no_o
oho66534382_oho
old47033462_old
ole37155212_ole
oleo46630482_oleo
olio46829672_olio
ono36838032_ono
ovolo8339172ovolo
oxo107322962_oxo
pal56761672pal_
pale66055012pale
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pele65539552pele
pelf97031452pelf
pelon74423212pelon
pelt67651082pelt
pepo87622152pepo
peso66925822peso
phlox1737332phlox
phono104917022phono
photo104417232photo
pile65649692pile
pili66130352pili
pill65339462pill
pilot77435062pilot
pily96132732pily
piso66727562piso
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
ply86323552p_ly
poboy121612222poboy
pock126129292pock
pod66351482po_d
pods76540152pods
poem86225772poem
poet65552902poet
pogy105623552pogy
poh86740532po_h
poi57244662po_i
poilu72316002poilu
pois66539042pois
poke105335362poke
poky135922152poky
polar75623452polar
poled84934842poled
poler74431792poler
poles75351002poles
polios84019722polios
polis74731162polis
polka11310412polka
polls74627722polls
polyol1138712polyol
polyp125611532polyp
polys105718762polys
pom78249912po_m
pome85636692pome
pomelo10238662pomelo
pomos95321582pomos
pomp106225462pomp
poms87037742poms
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
pood75934322pood
poof95541662poof
pooh96027382pooh
pools74427702pools
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252po_p
pope85535612pope
pops86340952pops
pore66451262pore
pork106929682pork
porn65636022porn
porno75120652porno
port66059632port
pose66441732pose
posh95427322posh
post67953362post
posy96028422posy
pot58078432po_t
pots66452362pots
potto75320942potto
pouf95732642pouf
poult76928872poult
pour611527472pour
pout65752552pout
pow87147282po_w
pows95537662pows
pox126140692po_x
poxy166820892poxy
poyou102611522poyou
prao66229022prao
pro55837262p_ro
prole74527792prole
prolog94212972prolog
promo95620002promo
proso77222412proso
pul56138062pul_
pula65129372pula
pule65040952pule
puli65527622puli
pull64731662pull
pulp84825352pulp
puls65437562puls
pylon103614002pylon
pyro96019392pyro
role45851822role
rolf75134872rolf
roll46331652roll
roto45935052roto
silo46037912silo
sol37256622sol_
sola45541862sola
sold54837412sold
soldo67116562soldo
sole46053672sole
soli46637012soli
solon55026132solon
solos54830792solos
sols45448162sols
spool75219042spool
tola45236332tola
told56132202told
tole46052902tole
toll45535262toll
tolu45529152tolu
too38965422to_o
tool46735682tool
topo66932402topo
toro48045682toro
toyo76925452toyo
vole75236982vole
volt76439532volt
wold85429072wold
wolf105729562wolf
woo66949802wo_o
wool76427372wool
yolk116218992yolk
zoo126238912zo_o

Search took 3 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 Filter178691298720.1561145455.1
2DLD Change Limit298722571.89015805.3
3Display Results2572570.1262039.7
 (SQL Overall)1786912572.17282270.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.