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

228 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
selecting1231053(None) 
electing112113781_electing
defecting162510222defecting
deflecting1736502deflecting
dejecting20217792dejecting
deleting103314422dele_ting
deselecting1544472deselecting
detecting13259982detecting
ejecting18268162_ejecting
erecting112415062_erecting
neglecting1444542neglecting
prelecting15310162prelecting
reelecting1338782reelecting
refecting152413352refecting
reflecting1638822reflecting
rejecting192211152rejecting
relenting102716772relenting
reletting102713942reletting
relucting1239772relucting
resecting122816482resecting
reselecting1446022reselecting
selection11311272selection
selections12310872selections
selective1449522selective
sklenting1475122sklenting
sleeting93114162s_leeting
advecting1645113advecting
affecting1845233affecting
alerting91312383_alerting
bedecking1934283bedecking
beflecking2243033beflecking
begetting13186583begetting
belching16349153bel_ching
beleaping1436743beleaping
belting104119133bel__ting
besetting12268423besetting
bisecting1436973bisecting
bleating113514503_bleating
celestine11147943celestine
cementing1438763cementing
cleating113518143_cleating
clefting14347583_clefting
coerecting15218783coerecting
collecting1548283collecting
decocting1538123decocting
deducting1436843deducting
defeating142311973defeating
defecating17237783defecating
delating103119603del_ating
deleading1237773deleading
deleaving1436263deleaving
delectating1545993delectating
delegating1337673delegating
deleing93313953dele__ing
delisting112710503delisting
dementing13311043dementing
depicting1537813depicting
depleting1378193deple_ting
deserting11713143deserting
detesting112610323detesting
devesting14249903devesting
directing1338823directing
effecting1845583effecting
egesting1039013_egesting
elating83423083_el_ating
election102015353_election
elections112414973_elections
elective13311003_elective
electroing1346903_electroing
elevating1338203_elevating
eliciting1237773_eliciting
eluting84115293_el_uting
enacting11311363_enacting
eructing112110173_eructing
everting122213133_everting
evicting1437483_evicting
exacting1838523_exacting
executing1945583_executing
exerting162211153_exerting
expecting2146693expecting
exsecting1935933exsecting
eyeletting1442873eyeletting
fellating1339253fellating
felting113515213fel__ting
fileting1239303file_ting
flecking18408233_flecking
fleeching18305013fleeching
fleecing14347573fleec_ing
fleeting122910323_fleeting
gelating103015733gel_ating
gleeting10279173_gleeting
helmeting1545503helmeting
infecting15109673infecting
inflecting1646313inflecting
injecting1997693injecting
inletting1087873inletting
leching134613653__leching
lectin82515013__lectin_
lectins92515003__lectins
leeching14318373le_eching
letting83218533__letting
meeting103314963me_e_ting
melting103317753mel__ting
molesting1237753molesting
mulcting13246983mul_cting
objecting2144053objecting
pelleting1237953pelleting
pelting102917273pel__ting
perfecting1847513perfecting
pleating112916053_pleating
praelecting1644533praelecting
preelecting1646473preelecting
preselecting1744293preselecting
reacting113317893re_acting
redacting13612303redacting
reejecting2045813reejecting
reerecting1339973reerecting
reesting93118273re_esting
reheating132314913reheating
relacing112516043relac_ing
relating92725443rel_ating
releasing10411013releasing
relegating1239483relegating
relending112412023relending
relisting102414353relisting
relocating13310873relocating
relocking16137683relocking
remeeting12311433remeeting
remelting12311703remelting
renesting102514703renesting
repeating122618983repeating
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
respecting1549883respecting
retesting102614603retesting
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
rewetting132710443rewetting
salting84120793sal__ting
saluting9310553sal_uting
scenting113212813s_centing
sealifting1444633sealifting
searching1538343searching
seating84130683s__eating
seceding12288563sece_ding
secerning1246203secerning
secreting1279823secreting
sedating103014113se_dating
seducing1236503seduc_ing
seeding93719483se_e_ding
seedling102610953se_edling
seeing74222143se_e__ing
seeking124016063se_e_king
seeling83522003se_e_ling
seeming103216263se_e_ming
seeping103817913se_e_ping
seething1239023se_ething
segmenting1445003segmenting
select82621173select___
selected1159783select_ed
selectee10910493select_ee
selectees1147013selectees
selectly1346563select_ly
selectman1343553selectman
selectmen1344613selectmen
selector1048623select_or
selectors1148973selectors
selects91912143select__s
selfing112911623sel__fing
selling83225833sel__ling
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
setting83621393s__etting
severing122013853seve_ring
sewering122411093sewe_ring
sheeting122712833s_heeting
shlepping1733393shlepping
silencing1245053silencing
silting83320483sil__ting
slacking153914133s_lacking
slanting94115093s_lanting
slating83724653s_l_ating
slatting94014233s_latting
sleaving123310983s_leaving
sledding11248503s_ledding
sledging11288183s_ledging
sleeking133410963s_leeking
sleeping113812053s_leeping
sleeving12359283s_leeving
sleuthing1334203s_leuthing
slewing113311353s_le_wing
slicing103514643s_lic_ing
slicking153712593s_licking
slitting93012583s_litting
slotting92612613s_lotting
smelting11339713s_melting
solacing11310133solac_ing
solating9315593sol_ating
solecising1345753solecising
solecizing2246473solecizing
soliciting1346813soliciting
solvating1336443solvating
speccing15306643s_peccing
specking17359733s_pecking
splatting1235983splatting
splicing1338963splic_ing
splinting1238193splinting
splitting1236563splitting
stetting93410713s_tetting
subjecting2245553subjecting
subletting1346273subletting
sulfating1338063sulfating
suspecting1565703suspecting
sweating123213023s_weating
sweeting123911313s_weeting
telecasting1443793telecasting
telexing1646613tele_xing
telneting1035593telneting
telnetting1143883telnetting
valeting1238853vale_ting
weeting113816053we_e_ting
welching17287363wel_ching
welting113615313wel__ting

Search took 9 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 Limit1486412287.51619776.6
3Display Results2282280.1102072.7
 (SQL Overall)1786912288.04922200.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.