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

185 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
polys10571876(None) 
ploys105816591ploys
poles75351001poles
polis74731161polis
polls74627721polls
polos76129911polos
pols66044561pol_s
poly96235151poly_
polyp125611531polyp
polyps13479761polyps
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
boys96737332bo_ys
cloys104916942cloys
colas75436772colas
colbys13407152colbys
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
coly96940532coly_
coys97537242co_ys
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
folds95221692folds
foleys123810462foleys
folks126017122folks
foys105628292fo_ys
golds75421312golds
golfs95616102golfs
goys86328412go_ys
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
holy106333432holy_
hoys107733932ho_ys
joeys15518042joeys
joles125230832joles
jolts125018882jolts
joys146624662jo_ys
kolas94822232kolas
kolos94921212kolos
lolls512121732lolls
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
moly96031912moly_
nolos54423352nolos
olds55926572_olds
oles46453472_oles
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
palsy105417462palsy
paly95835532paly_
pays95940222p_ays
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pily96132732pily_
plays106320772plays
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploy96123602ploy_
plus66324832p_lus
ply86323552p_ly_
poboys1397312poboys
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poesy105014062poesy
poets76024442poets
pogeys124110352pogeys
pogy105623552pogy_
poilus82210572poilus
pois66539042po_is
pokes116133012pokes
pokeys15529512pokeys
poky135922152poky_
pol56449382pol__
polar75623452polar
polars84419352polars
pole65951302pol_e
poled84934842poled
poleis86018352poleis
poler74431792poler
polers84225642polers
poleyn1157322poleyn
poleyns1236112poleyns
polies84034582polies
polio75722552polio
polios84019722polios
polish114916722polish
polka11310412polka
polkas1239102polkas
poll66332132pol_l
polo66236632pol_o
polyol1138712polyol
polyols1238492polyols
polypi13458592polypi
polypus14346932polypus
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
pony96434052pony_
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112po_os
popes95933812popes
pops86340952po_ps
popsy125713402popsy
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
posts75228782posts
posy96028422posy_
pots66452362po_ts
potsy105815612potsy
poufs105616062poufs
poults84613482poults
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
poxy166820892poxy_
prays105022432prays
preys105717782preys
proles84627202proles
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
soys75233932so_ys
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tolyl84710092tolyl
tolyls9436962tolyls
toys78036342to_ys
voles86234042voles
volts85421292volts
wolds95420182wolds
wolfs116214162wolfs
yolks125412772yolks

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.310576422.6
2DLD Change Limit538001851.58034050.6
3Display Results1851850.0464021.7
 (SQL Overall)1786911851.93692299.1
 
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.