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

158 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
polluted113543(None) 
pollute937381pollute_
polluter1035401polluter
pollutes1037611pollutes
collated113615062collated
colleted113011652colleted
colluded12296452colluded
palleted1139862palleted
pelleted1138182pelleted
polled94022002poll__ed
pollened1157772pollened
pollster1037102pollster
polluters1135032polluters
pouted94021392po__uted
unpolluted1342132unpolluted
voluted11297942vo_luted
abluted10188363_abluted
alluded9327093_alluded
allured8299173_allured
balloted1189043balloted
ballute938543ballute_
ballutes1037523ballutes
billeted1137643billeted
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
bolted94617803bo_l_ted
bulleted1138393bulleted
callused1135853callused
clouted104212163_clouted
collaged12279963collaged
collared113211143collared
collate92919683collate_
collates103019133collates
collected1447963collected
collided12309793collided
collied103316673coll_ied
collude10337983collude_
colluder11276863colluder
colludes11279213colludes
coloured1148303coloured
commuted15288963commuted
computed154110943computed
confuted1437673confuted
cornuted1137463cornuted
diluted9248933_diluted
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
eluted74915263__eluted
fellated1239563fellated
filleted1236603filleted
flouted113210813_flouted
fluted104917163__fluted
foliated1249913foliated
followed15146273followed
galleted1038213galleted
gallused1034193gallused
glouted9429713_glouted
hollaed11359853holl_aed
hollered1237603hollered
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157023hollowed
illuded9305763_illuded
illumed10285863_illumed
jollied15349273joll_ied
jolted143510633jo_l_ted
lolled74315823loll__ed
lolloped1134463lolloped
louted74920693__louted
luted64826143___luted
molested11178243molested
molted94217473mo_l_ted
moulted103310313moul_ted
outed65429063_o__uted
palled94625163pall__ed
palliated1238493palliated
palmated132511003palmated
palpated13249763palpated
pellucid1343003pellucid
pelted94617753p_el_ted
peplumed1543013peplumed
permuted1336703permuted
pileated112711133pileated
pillaged12298083pillaged
pillared11228083pillared
pilled94222753pill__ed
pillowed14156383pillowed
piloted10310323p_iloted
plaited103713893p_laited
planted103516123p_lanted
plated95225773p__lated
platted103614263p_latted
pleated103816633p_leated
plotted104612373p_lotted
plumed114412883p__lumed
plutei8408903p__lutei
pocketed17147143pocketed
pointed103813983po_inted
poleaxed1854813poleaxed
poled84934843po_l__ed
policed123212233po_liced
polished1468433polished
polite83625073po_lite_
politer92417073po_liter
polkaed1435323po_lkaed
pollard103511143poll_ard
pollarded1344703pollarded
pollee83623273poll__ee
pollees93215333poll_ees
pollen83416453poll__en
pollenated1345013pollenated
poller83921853poll__er
pollex153711163poll__ex
pollices12410753pollices
pollinated1345823pollinated
pollsters1137173pollsters
pollutant1144203pollutant
polluting1235703polluting
pollution1146003pollution
pollutive1444713pollutive
polyped1537173po_lyped
pooled94619813pool__ed
poplitei1245483poplitei
populated14228803populated
ported94223243po__rted
posited10511493po_sited
posted93722493po__sted
postured1139493postured
potted94624013po__tted
poufed12449713po__ufed
poulter93712013poul_ter
poured95116743po__ured
pouter83923983po__uter
preluded1236453preluded
pulled94322193pull__ed
pullulated1343253pullulated
pulsated1136853pulsated
rolled74220243roll__ed
routed75624333ro__uted
saluted84511703_saluted
solated83618023so_lated
solute64016663so_lute_
solutes73515263so_lutes
solvated12237443solvated
spoliated1246913spoliated
spouted103412263spo__uted
toileted936993toileted
tolled73819033toll__ed
touted74419743to__uted
umlauted1132823umlauted
unfluted1237173unfluted
volleyed1543533volleyed
volumed13285683vo_lumed
volute93912763vo_lute_
volutes102710983vo_lutes

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621587.31319986.6
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.52923733.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.