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

157 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
indexer1528725(None) 
indexed16347361indexed
indexers16326371indexers
indexes15339451indexes
hinderer1238272hinderer
indeed83913562inde_ed
indene73215372indene_
indenes82916252indenes
indenter92311442indenter
index13310982index__
inditer83514232inditer
inducer10318762inducer
integer837992integer
annexe1337813annexe_
annexed1535753annexed
annexes1437203annexes
binder94422873bind__er
cinder94119123cind__er
cindered1239793cindered
deer56739023__de_er
defer94619753__defer
deter65028043__deter
dexes135224513__dexes
dexter143810893__dexter
diplexer1844213diplexer
endear74110013ende_ar
ender64325863end__er
endower1138483endower
endurer83210363endurer
enfever1344643enfever
enterer72015633enterer
fedexed1934083fedexed
fedexes1835473fedexes
finder104020233find__er
fingerer12127223fingerer
hexer155116683__hexer
hinder104120063hind__er
hindered1339453hindered
hinderers1337353hinderers
ibexes15436163i_bexes
idler65015663i_d_ler
ilexes134510253i_lexes
impeder12438533impeder
inaner62213543in_aner
incenter102212093incenter
incher114114033in_cher
inciter93113773inciter
incomer1169943incomer
indebted12246873indebted
indecent11411273indecent
indent73021243inde_nt
indented101811733indented
indenters102710033indenters
indentor9288513indentor
indents83114663indents
indexing1737123indexing
indices103513443indices
indicter1148143indicter
indie63721473ind_ie_
indies73822783ind_ies
indigen9319333indigen
indite73520323indite_
indited93515023indited
inditers93311053inditers
indites83618983indites
indole74516053indole_
indoles83716363indoles
indoor738403ind_oor
indorser985713indorser
indowed1237443indowed
indoxyl1842423indoxyl
induce93811533induce_
induced11298933induced
inducers11326953inducers
induces103611813induces
indue63516673ind_ue_
indued83411653ind_ued
indues73515263ind_ues
indulger1044153indulger
indweller1393013indweller
inexpert1746083in_expert
infecter13229153infecter
infer84215033in__fer
inferrer11217443inferrer
infester11239433infester
infixed18206563infixed
infixes17238133infixes
inflexed1944023inflexed
infuser10298323infuser
inhaler1068053inhaler
inhere9313713inhere_
inhered11313163inhered
inheres10315173inheres
inhumer1275383inhumer
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlayer1036933inlayer
inlier63615363in_lier
inner54920633in__ner
insaner7310443insaner
inserter82312133inserter
insetter8218593insetter
insider849733insider
insurer73312803insurer
integers937783integers
intender93310443intender
intenser8199443intenser
inter55028493in__ter
intoner7811673intoner
invader11146453invader
inventer112410843inventer
inverter112411073inverter
inviter104112313inviter
invoker1435363invoker
iodizer17408663iodizer
kinder113716843kind__er
kindler12309983kind_ler
kindlier1345763kindlier
kneeler11277573kneeler
lingerer9118303lingerer
minder94822503mind__er
modeler1039293modeler
needer73614953_needer
never86218643_n_ever
newer85717463_n_ewer
orderer8127943orderer
panderer112210913panderer
pinder94523453pind__er
ponderer112410193ponderer
reindeer936293reinde_er
reindexed1843883reindexed
reindexes1744293reindexes
renderer9239743renderer
sincerer1037203sincerer
sneer54919953sn_e_er
sneerer73512313sneerer
sneezer16237963sneezer
sunderer9310523sunderer
tenderer9228733tenderer
tinder73821803tind__er
tinkerer1286803tinkerer
undee65327273unde_e_
under64624213und__er
undoer73113043und_oer
unindexed1843063unindexed
unsexed152410253unsexed
unsexes14248923unsexes
unvexed18147103unvexed
vexer155513523__vexer
wanderer122210123wanderer
widener11318693widener
winder104025263wind__er
windier113412163wind_ier
winterer112110443winterer
wonderer12249183wonderer
yodeler1136343yodeler

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271575.81323056.4
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.26528522.1
 
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.