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

121 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
indexers1632637(None) 
indexer15287251indexer_
indexes15339451indexe_s
hinderers1337352hinderers
indenes82916252indene_s
indenters102710032indenters
indexed16347362indexe_d
inditers93311052inditers
inducers11326952inducers
integers937782integers
annexes1437203annexe_s
binders103920743bind__ers
cinders104617763cind__ers
deers64930523__de_ers
defers105116943__defers
deters74724683__deters
dexes135224513__dexe_s
diplexers1943573diplexers
endears83710053ende_ars
enders74324053end__ers
endowers1238233endowers
endurers9317953endurers
enfevers1444513enfevers
enterers82214153enterers
fedexes1835473fedexe_s
finders113717873find__ers
fingerers13136303fingerers
hexers165612753__hexers
hinderer1238273hinderer_
hinders113718503hind__ers
ibexes15436163i_bexe_s
idlers74012813i_d_lers
ilexes134510253i_lexe_s
impeders13346593impeders
incenters112510303incenters
inchers123912523in_chers
inciters103210673inciters
incomers1268593incomers
indecent11411273indecent
indeed83913563inde_e_d
indene73215373indene__
indenter92311443indenter_
indentors10278313indentors
indents83114663inde_nts
index13310983index___
indexing1737123indexing
indexings1843693indexings
indices103513443indice_s
indicters1236733indicters
indies73822783ind_ie_s
indigens10288733indigens
inditer83514233inditer_
indites83618983indite_s
indoles83716363indole_s
indoors838553ind_oors
indorsers1075383indorsers
indoxyls1942253indoxyls
inducer10318763inducer_
induces103611813induce_s
indues73515263ind_ue_s
indulgers1143803indulgers
indwellers1472353indwellers
inexpert1746083in_expert
inexperts1842973in_experts
infecters14257583infecters
inferrers12226583inferrers
infers93615443in__fers
infesters12237713infesters
infixes17238133infixe_s
infusers11286143infusers
inhalers1166643inhalers
inheres10315173inhere_s
inhumers1364823inhumers
injurers15286123injurers
inkers104018833in__kers
inlayers1135643inlayers
inliers73110743in_liers
inners63919353in__ners
inserters92210283inserters
insetters9187133insetters
insiders947763insiders
insurers83710133insurers
integer837993integer_
intenders10219373intenders
inters64328053in__ters
intoners889933intoners
invaders12105303invaders
inventers12269533inventers
inverters12239753inverters
inviters11359643inviters
invokers1534673invokers
iodizers18316123iodizers
kindlers13318483kind_lers
kneelers12226213kneelers
lingerers10126923lingerers
minders103720123mind__ers
modelers1138463modelers
needers84111903_needers
orderers9116563orderers
panderers12229153panderers
pinders103720473pind__ers
ponderers12248453ponderers
reindeers1044873reinde_ers
reindexes1744293reindexe_s
renderers10208093renderers
sneerers8309803sneerers
sneers64016173sn_e_ers
sneezers17246143sneezers
sunderers1039073sunderers
tenderers10227803tenderers
tinders84219173tind__ers
tinkerers1395423tinkerers
undoers82910583und_oers
unsexes14248923unsexe_s
vexers165210403__vexers
wanderers13228483wanderers
wideners12257993wideners
winders113721263wind__ers
winterers12209723winterers
wonderers13217933wonderers
yodelers1235673yodelers

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.423422437.4
2DLD Change Limit1461621216.70321805.5
3Display Results1211210.0631920.6
 (SQL Overall)1786911217.18924856.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.