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

166 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
infester1123943(None) 
infecter13229151infecter
infested12249641infested
infesters12237711infesters
enfetter1145352enfetter
fester94723512__fester
incenter102212092incenter
indenter92311442indenter
infected14229402infected
infecters14257582infecters
infector13478852infector
inferrer11217442inferrer
infest93315432infest__
infests10279792infest_s
inflater1149892inflater
infuser10298322infus_er
ingested10259002ingested
inserter82312132inserter
insetter8218592insetter
insister888782insister
inventer112410842inventer
inverter112411072inverter
invested12229692invested
investor11247412investor
nester64124182_n_ester
unfetter1136752unfetter
affecter1644523affecter
ancestor1046853ancestor
anteater8311603anteater
arrester839253arrester
attester836503attester
bimester1236163bimester
contester11311183contester
defeater122611663defeater
detester9239683detester
diester83013683_diester
digester10258433digester
dopester1137253dopester
effecter1664773effecter
enfetters1244463enfetters
enfever1344643enfe_ver
enlister847803enlister
ester54727713___ester
faster94625773__faster
feaster10812983__feaster
feater95224053__feater
festers104121393__festers
fetter94120383__fetter
forester11313673forester
foster94322223__foster
gamester1137323gamester
honester1139713honester
imposter12288163imposter
incented112412543incented
incenters112510303incenters
incepted13177773incepted
inceptor1246023inceptor
incest82918743incest__
incests92711383incest_s
inciter93113773in_citer
indebted12246873indebted
indented101811733indented
indenters102710033indenters
indentor9288513indentor
indexer15287253inde_xer
indicter1148143indicter
inditer83514233in_diter
infante101910883infante_
infantes11249633infantes
infect113413443infect__
infectors14218553infectors
infects12279713infect_s
infer84215033inf___er
inferior1156423inferior
inferred12248353inferred
inferrers12226583inferrers
infestant1247233infestant
infesting13109513infesting
infielder1343173infielder
infighter1644273infighter
inflamer1356123inflamer
inflate10312313inflate_
inflated12410863inflated
inflaters1247543inflaters
inflates11512193inflates
inflator1158033inflator
inflected1546053inflected
inflector1465353inflector
inflicter1444453inflicter
infolder1256433infolder
informer13227283informer
infuse93110573infus_e_
infused11329253infus_ed
infusers11286143infus_ers
infuses102711873infus_es
ingest73119003ingest__
ingesta8357863ingest_a
ingests83210983ingest_s
injected18226753injected
injector17236933injector
inmeshed1444483inmeshed
inmeshes1345613inmeshes
inputter1034203inputter
inserted92413053inserted
inserters92210283inserters
insetted9249023insetted
insetters9187133insetters
insisted998673insisted
insisters997653insisters
instar6310013in__star
instep838193in__step
insulter836883insulter
integer837993inte_ger
intender93310443intender
intenser8199443intenser
inter55028493in___ter
interterm1148813interterm
invected14258883invected
invented122510663invented
inventers12269533inventers
inventor11298153inventor
inverted122312163inverted
inverters12239753inverters
invertor11238973invertor
invest93014843invest__
investors12227723investors
invests10319683invest_s
inviter104112313in_viter
jester134319153__jester
jokester1934443jokester
keester11319913_keester
kiester11329973_kiester
manifester1543133manifester
minister10410363min_ister
minster93914323min__ster
modester1197483modester
molester1099373molester
monoester1146453monoester
neater64424313_n_eater
nested74720063_n_ested
nesters74422793_n_esters
nestler73510443_n_estler
nestor63713423_n_estor
netter63722023_n_etter
neuter63713793_n_euter
pester84827593__pester
pinaster1037113pin_aster
pinfeather1851843pinfeather
pinsetter1145013pinsetter
prester93519623_prester
quester161410023_quester
rester63832433__rester
rimester1037813rimester
semester1038903semester
sinister838583sin_ister
tester64227153__tester
unfasten1144843unfasten
unfelted1279403unfelted
unfetters1244363unfetters
unrested91914513unrested
untested92612413untested
unvested122210223unvested
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
zester153617793__zester

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.420425454.8
2DLD Change Limit1461621667.50319480.5
3Display Results1661660.0762184.2
 (SQL Overall)1786911667.99922339.2
 
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.