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

128 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
polluter103540(None) 
pollster1037101pollster
pollute937381pollute_
polluted1135431polluted
polluters1135031polluters
pollutes1037611pollutes
colluder11276872colluder
politer92417072po_liter
poller83921852poll__er
pollsters1137172pollsters
poulter93712012poul_ter
pouter83923982po__uter
allurer7348433_allurer
balloter1078893balloter
ballute938543ballute_
ballutes1037523ballutes
billeter1037563billeter
bolster93713423bo_lster
bolter83920753bo_l_ter
clouter93511693_clouter
collate92919683collate_
collated113615063collated
collates103019143collates
collator10310373collator
colleger11227933colleger
colleted113011663colleted
collider113410423collider
collier93618153coll_ier
collude10337993collude_
colluded12296463colluded
colluders12285613colluders
colludes11279223colludes
colourer1037563colourer
colter84625093co_l_ter
commuter143010153commuter
computer144511513computer
confuter1338513confuter
coulter94115603coul_ter
couter84930223co__uter
diluter8319663_diluter
flouter104311343_flouter
fluter95316863__fluter
follower14137073follower
holler93520613holl__er
hollower14127393hollower
holster103512213ho_lster
jollier142911003joll_ier
jolter133513093jo_l_ter
loller63315283loll__er
molester1099373molester
molter84119423mo_l_ter
moulter93812423moul_ter
oldster896573_oldster
outer55633303_o__uter
palleted1139863palleted
pallier94417163pall_ier
palter84423263p_al_ter
pelleted1138193pelleted
pelter83321623p_el_ter
philter12108213phil_ter
pilaster1038163pilaster
pillager11278553pillager
plaiter93615393p_laiter
planter94017803p_lanter
plaster93318693p_laster
plater84427693p__later
platter93917413p_latter
pleater93916333p_leater
plotter94113663p_lotter
plutei8408903p__lutei
pocketer16157373pocketer
pointer93814933po_inter
polder94019253po_l_der
poler74431793po_l__er
polestar1047113polestar
policer113112683po_licer
polisher1388073polisher
polite83625073po_lite_
polled94022003poll__ed
pollee83623273poll__ee
pollees93215333poll_ees
pollen83416453poll__en
pollened1157773pollened
pollers93420023poll__ers
pollex153711163poll__ex
pollices12410753pollices
polltaker1542723polltaker
pollutant1144203pollutant
polluting1235703polluting
pollution1146003pollution
pollutive1444713pollutive
polyester1445353polyester
polymer1438063po_lymer
polywater1774783polywater
poofter1237163po_ofter
pooler83819843pool__er
poplitei1245483poplitei
porter84224413po__rter
poster84129173po__ster
posturer1038923posturer
pothunter1443513pothunter
potter83926983po__tter
poulters103911053poul_ters
pourer84516043po__urer
pouted94021393po__uted
pouters94221873po__uters
poutier93215323po__utier
powter114116033po__wter
preluder1135733preluder
psalter9247813psal_ter
puller83820813pull__er
pullover13134643pullover
roller63919793roll__er
rollover1144453rollover
router65025843ro__uter
saluter73512453_saluter
solute64016663so_lute_
solutes73515263so_lutes
souter64225923so__uter
spouter94213223spo__uter
toller63819443toll__er
touter63821033to__uter
unpolluted1342133unpolluted
volleyer1443163volleyer
volute93912763vo_lute_
voluted11297943vo_luted
volutes102710983vo_lutes
zoolater1746093zoolater

Search took 9 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 Limit1461621287.97018339.0
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.17221866.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.