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

130 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
infesters1223771(None) 
infecters14257581infecters
infester11239431infester_
enfetters1244462enfetters
festers104121392__festers
incenters112510302incenters
indenters102710032indenters
infecter13229152infecter_
infectors14218552infectors
inferrers12226582inferrers
infested12249642infeste_d
infests10279792infest__s
inflaters1247542inflaters
infusers11286142infus_ers
inserters92210282inserters
insetters9187132insetters
insisters997652insisters
inventers12269532inventers
inverters12239752inverters
investors12227722investors
nesters74422792_n_esters
unfetters1244362unfetters
affecters1763933affecters
ancestors1147233ancestors
anteaters939343anteaters
arresters948193arresters
attesters935803attesters
bimesters1336343bimesters
contesters12410183contesters
defeaters13289103defeaters
detesters10298303detesters
diesters92513603_diesters
digesters11257883digesters
dopesters1237283dopesters
effecters1764323effecters
enfetter1145353enfetter_
enfevers1444513enfe_vers
enlisters937113enlisters
esters64627733___esters
feasters11511563__feasters
fester94723513__fester_
fetters103517903__fetters
foresters12312533foresters
fosters104220103__fosters
gamesters1236733gamesters
imposters13347343imposters
incenter102212093incenter_
inceptors1345773inceptors
incests92711383incest__s
inciters103210673in_citers
indenter92311443indenter_
indentors10278313indentors
indexers16326373inde_xers
indicters1236733indicters
inditers93311053in_diters
infantes11249633infante_s
infected14229403infecte_d
infector13478853infector_
infects12279713infect__s
inferiors1266543inferiors
inferrer11217443inferrer_
infers93615443inf___ers
infest93315433infest___
infestant1247233infestant
infestants1344503infestants
infesting13109513infesting
infielders1442623infielders
infighters1743323infighters
inflamers1455213inflamers
inflater1149893inflater_
inflates11512193inflate_s
inflators1257713inflators
inflectors1545223inflectors
inflicters1543453inflicters
infolders1385173infolders
informers14206133informers
infuser10298323infus_er_
infuses102711873infus_e_s
ingested10259003ingeste_d
ingests83210983ingest__s
injectors18216723injectors
inmeshes1345613inmeshe_s
inputters1143443inputters
inserter82312133inserter_
insetter8218593insetter_
insister888783insister_
instars7411133in__stars
insteps936573in__steps
insulters945883insulters
integers937783inte_gers
intenders10219373intenders
inters64328053in___ters
interterm1148813interterm
inventer112410843inventer_
inventors12288253inventors
inverter112411073inverter_
invertors12239793invertors
invested12229693investe_d
investor11247413investor_
invests10319683invest__s
inviters11359643in_viters
jesters144118193__jesters
jokesters2044443jokesters
keesters12319593_keesters
kiesters123310153_kiesters
manifesters1652753manifesters
ministers1139623min_isters
minsters103813923min__sters
molesters1198873molesters
monoesters1245993monoesters
nester64124183_n_ester_
nestlers8359223_n_estlers
nestors73614973_n_estors
netters73618583_n_etters
neuters74212273_n_euters
pesters93827093__pesters
pinasters1136823pin_asters
pinfeathers1951793pinfeathers
pinsetters1244103pinsetters
presters103419003_presters
questers17168763_questers
resters74130403__resters
rimesters1137483rimesters
semesters1139123semesters
testers74124543__testers
unfastens1242983unfastens
unfetter1136753unfetter_
westers105221963__westers
wresters112711733_wresters
zesters163517293__zesters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411306.79621871.8
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.28224538.7
 
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.