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

136 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
incenters11251030(None) 
incenter102212091incenter_
indenters102710031indenters
inventers12269531inventers
centers94420602__centers
concenters14410582concenters
decenters122410372decenters
incenses102411002incense_s
incented112412542incente_d
incents92414532incent__s
inceptors1345772inceptors
inciters103210672inc_iters
indenter92311442indenter_
indentors10278312indentors
infecters14257582infecters
infesters12237712infesters
inserters92210282inserters
insetters9187132insetters
intenders10219372intenders
inventer112410842inventer_
inventors12288252inventors
inverters12239752inverters
absenters1156173absenters
accentors13116053accentors
accepters15114603accepters
ancestors1147233ancestors
ancienter1145393ancienter_
anointers937003anointers
anteaters939343anteaters
ascenders1235683ascenders
assenters966993assenters
canters94827733__canters
cementers1338313cementers
censers94313903__censers
center84421413__center_
centners1057243__centners
centres93817123__centres
concenter13312213concenter_
consenters12410843consenters
decanters12229223decanters
decenter112412163decenter_
decentres12238523decentres
dissenters1197723dissenters
enceintes1145673enceinte_s
enchanters1545223enchanters
encounters1244553encounters
enfetters1244463enfetters
engenders1145303engenders
ententes8312773entente_s
enters64425643___enters
epicenters14114463epicenters
fomenters1437853fomenters
incanted11259543incante_d
incants92012803incant__s
incense92410303incense__
incensed11277953incense_d
incent83320723incent___
incenting12912063incenting
incentive1489603incentive
incentives1578043incentives
incepted13177773incepte_d
inceptor1246023inceptor_
incepts11238283incept__s
incests92711383incest__s
inchers123912523inc__hers
inciter93113773inc_iter_
incites93218483inc_ite_s
incliners1146333incliners
inclosers11155563inclosers
incomers1268593inc_omers
increasers1243313increasers
incumbers1544003incumbers
indecenter1345023indecenter_
indenes82916253inden_e_s
indented101811733indente_d
indentor9288513indentor_
indents83114663indent__s
indenture1045063indenture
indentures1144863indentures
indexers16326373inde_xers
indicters1236733indicters
inditers93311053in_diters
infantes11249633infante_s
infecter13229153infecter_
infectors14218553infectors
inferrers12226583inferrers
infester11239433infester_
inflaters1247543inflaters
ingenues947103ingenue_s
injectors18216723injectors
inlanders1036143inlanders
inners63919353in__n_ers
innocenter1252903innocenter_
inputters1143443inputters
inserter82312133inserter_
insetter8218593insetter_
insisters997653insisters
insulters945883insulters
integers937783inte_gers
intendeds11265743intendeds
intender93310443intender_
intenser8199443intenser_
intentness1047363intentness
intents72115703intent__s
inters64328053i___nters
interterm1148813interterm
intoners889933inton_ers
invented122510663invente_d
inventor11298153inventor_
inventory15255633inventory
inventress1343623inventress
invents102812053invent__s
inverter112411073inverter_
invertors12239793invertors
investors12227723investors
inviters11359643in_viters
lamenters1137683lamenters
licencers13134643licencers
licensers11114583licensers
misenters1139533misenters
nesters74422793_n_esters
netters73618583_n_etters
neuters74212273_n_euters
niceness1039843nicen_ess
orienters937613orienters
pinsetters1244103pinsetters
recanters112310483recanters
recenter102715443recenter_
reenters82915303_reenters
renters74224813__renters
repenters112511553repenters
scepters1237793_scepters
subcenters1446163subcenters
tenters73921103__tenters
unfetters1244363unfetters
venters103717733__venters

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.406440125.6
2DLD Change Limit1486411367.00021234.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.46923924.4
 
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.