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

114 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
infecters1425758(None) 
infecter13229151infecter_
infectors14218551infectors
infesters12237711infesters
affecters1763932affecters
effecters1764322effecters
enfetters1244462enfetters
incenters112510302incenters
indenters102710032indenters
indicters1236732indicters
infected14229402infecte_d
infector13478852infector_
infects12279712infect__s
inferrers12226582inferrers
infester11239432infester_
inflaters1247542inflaters
inflectors1545222inflectors
inflicters1543452inflicters
injectors18216722injectors
inserters92210282inserters
insetters9187132insetters
inventers12269532inventers
inverters12239752inverters
unfetters1244362unfetters
affecter1644523affecter_
anteaters939343anteaters
connecters1448013connecters
defeaters13289103defeaters
defectors15237883defectors
detecters12217753detecters
effecter1664773effecter_
effectors1755033effectors
enfetter1145353enfetter_
enfevers1444513enfe_vers
erecters102611613_erecters
expecters2045473expecters
festers104121393__festers
fetters103517903__fetters
impacters15305483impacters
incenter102212093incenter_
inceptors1345773inceptors
inchers123912523in__chers
inciters103210673in_citers
indenter92311443indenter_
indentors10278313indentors
indexers16326373inde_xers
indictees1246163indictees
indicter1148143indicter_
indictors1247623indictors
inditers93311053in_diters
inducers11326953induc_ers
inductees1244713inductees
inductors1246223inductors
infantes11249633infante_s
infect113413443infect___
infectant1446833infectant
infecting15109673infecting
infection14410473infection
infections15510233infections
infectious1545603infectious
infective17108973infective
inferiors1266543inferiors
inferrer11217443inferrer_
infers93615443inf___ers
infested12249643infeste_d
infests10279793infest__s
infielders1442623infielders
infighters1743323infighters
inflamers1455213inflamers
inflater1149893inflater_
inflates11512193inflate_s
inflators1257713inflators
inflected1546053inflecte_d
inflector1465353inflector_
inflects1336193inflect__s
inflicter1444453inflicter_
inflictors1543953inflictors
infolders1385173infolders
informers14206133informers
infractors1566003infractors
infusers11286143inf_users
injected18226753injecte_d
injector17236933injector_
injects16257453inject__s
inputters1143443inputters
insectary1444213insectary
insects93710843insect__s
inserter82312133inserter_
insetter8218593insetter_
insisters997653insisters
inspectors1444933inspectors
insulters945883insulters
integers937783inte_gers
intenders10219373intenders
inters64328053in___ters
interterm1148813interterm
invected14258883invecte_d
inventer112410843inventer_
inventors12288253inventors
inverter112411073inverter_
invertors12239793invertors
investors12227723investors
inviters11359643in_viters
neckers134210463_n_eckers
nectars938463_n_ectars
nesters74422793_n_esters
netters73618583_n_etters
neuters74212273_n_euters
perfecters1745433perfecters
pinfeathers1951793pinfeathers
pinsetters1244103pinsetters
rejecters18257543rejecters
specters122811063_specters
unfetter1136753unfetter_

Search took 7 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.420425454.8
2DLD Change Limit1486411146.03324638.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.49927495.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.