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

331 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
existing163907(None) 
exiting15311391exi_ting
agisting1038242agisting
bemisting1438072bemisting
coexisting2044402coexisting
delisting112710502delisting
desisting112810382desisting
easting84924302e_asting
editing9313132edi_ting
egesting1039012egesting
emitting112410352emitting
enisling949632enisling
enlisting1038342enlisting
evicting1437482evicting
eviting11511372evi_ting
exacting1838522exacting
exalting1638032exalting
excising1837212excis_ing
exciting1838012exciting
exerting162211152exerting
exiling15311082exi_ling
existent1548262existent
expiating1938532expiating
exulting1637642exulting
fisting113818122_fisting
foisting122910502foisting
heisting123411042heisting
histing113720372_histing
hoisting123610902hoisting
joisting16328502joisting
listing84020592_listing
misting103623382_misting
relisting102414352relisting
resisting103215312resisting
twisting12427812twisting
waisting123615212waisting
whisting15329542whisting
wisting113519742_wisting
airting83616303_airting
arising83619973aris_ing
assisting1046183assisting
aviating12311013aviating
baiting103918883bai_ting
basting104227203_basting
befitting15236623befitting
bekissing1643503bekissing
besting104923923_besting
biting95321823_bi_ting
bitting103717293_bitting
blasting114013423blasting
blissing1136873blissing
boasting113512493boasting
boosting113311053boosting
brisking15329473brisking
brisling112410843brisling
bristling1246663bristling
bursting1138703bursting
busting104221793_busting
casting104628343_casting
citing94220183_ci_ting
coasting113615513coasting
costing104323023_costing
cresting114017043cresting
crisping13319663crisping
crusting113612793crusting
debiting122511203debi_ting
degusting1236163degusting
dehiscing1643733dehiscing
demasting1338453demasting
demising122012523demis_ing
demitting13239073demitting
depicting1537813depicting
detesting112610323detesting
devesting14249903devesting
deviating14311083deviating
devising133111523devis_ing
dieting93616833_dieting
dinting93520553_dinting
discing113914593_discing
dishing124017103_dishing
disking134615493_disking
dissing94517683_dissing
drifting13338733drifting
dusting93618993_dusting
easing74926463e_as_ing
eastings93412953e_astings
eating75134403e__ating
edifying1636083edifying
ejecting18268163ejecting
ekistic1377843ekisti_c
ekistics1485703ekistics
elastin72611843elastin_
elastins82111733elastins
elating83423083e_lating
electing112113783electing
eliciting1237773eliciting
eliding93414343eli_ding
eluting84115293e_luting
emoting10313563e_moting
enacting11311363enacting
encysting1544613encysting
enditing10311073enditing
ensiling9410723ensiling
ensuing8239543e_nsuing
entwisting1443853entwisting
epilating12310963epilating
equating18310113equating
erasing8317963eras_ing
erecting112415063erecting
eristic9814093eristi_c
eristics10610193eristics
eructing112110173eructing
erupting11218443erupting
escoting1158713escoting
estating92614993estating
everting122213133everting
evincing1446183evincing
excepting2145873excepting
excessing1945713excessing
exciding1935923exciding
excreting1946433excreting
excusing1836503excusing
executing1945583executing
exempting2144223exempting
exhaling1936293exhaling
exhausting2143153exhausting
exhibiting2343623exhibiting
exhorting2045733exhorting
exhuming2143303exhuming
exing136016813ex___ing
exist124618943exist___
existed1538473exist_ed
existence1845413existence
existents1644983existents
exists134710913exist__s
expecting2146693expecting
experting1938053experting
expiring1836253expiring
exporting1937323exporting
exposing1836673exposing
expositing2045343expositing
exscind1743753ex_scind
exsecting1935933exsecting
exserting1736663exserting
extincting2043993extincting
extorting1746763extorting
exuding16347443ex_uding
exuviating2144513exuviating
fainting123312163fainting
fasting114522833_fasting
feasting122011323feasting
feinting123410833feinting
fishing143913863_fishing
fitting113516563_fitting
fixating1936183fixating
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
frisking16268363frisking
fritting123510703fritting
frosting12311183frosting
gaiting93716583gai_ting
gasting95022763_gasting
ghosting1336463ghosting
gifting123810893_gifting
girting93113333_girting
gitting93215703_gitting
glinting103210053glinting
grifting13299263grifting
gritting10309983gritting
guesting1058463guesting
guising93511413guis_ing
gusting93917163_gusting
hasting114725193_hasting
hilting113316893_hilting
hinting113919223_hinting
hissing114213143_hissing
hitting113017273_hitting
hoising113414413hois_ing
hosting114318383_hosting
insisting1038823insisting
irising83614423iris_ing
isling71213883__isling
jesting154317713_jesting
jilting153211743_jilting
jointing16248613jointing
jousting16309353jousting
justing153615163_justing
kilting123213853_kilting
kissing122911053_kissing
kiting114117093_ki_ting
kitting123214443_kitting
knitting13257023knitting
lasting84725243_lasting
leniting9312353leni_ting
lifting113313273_lifting
lilting83515383_lilting
linting83820983_linting
lisping103412753_lisping
listings93310043_listings
lusting83619323_lusting
masting104325823_masting
mediating13311203mediating
meriting11314683meri_ting
milting103619123_milting
minting103020813_minting
missing103619073_missing
musting103221073_musting
nesting84320443_nesting
noising83615173nois_ing
omitting11217743omitting
opiating11410093opiating
ousting84021353_ousting
oxidating1845053oxidating
painting113614423painting
pasting103826553_pasting
peising103416763peis_ing
perishing1539533perishing
persisting1346653persisting
pishing134314373_pishing
pissing103914803_pissing
pitting103618873_pitting
pointing112813683pointing
poising103617103pois_ing
positing11312303positing
posting105622243_posting
preexisting2144223preexisting
priesting1239483priesting
printing113216083printing
prising103321453pris_ing
prissing113011453prissing
pristine10313503pristine
questing1838273questing
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quisling18218063quisling
quitting18228833quitting
raising83220533rais_ing
recasting122414233recasting
reciting113118073reci_ting
reesting93118273reesting
refitting132811123refitting
relishing13229183relishing
reminting122315103reminting
remising112516453remis_ing
remitting122412623remitting
renesting102514703renesting
repasting122312833repasting
rerising93017783reris_ing
resifting133512093resifting
resiting93521123resi_ting
resitting103414873resitting
resting85031183_resting
retasting102513413retasting
retesting102614603retesting
retinting102215253retinting
retwisting1445633retwisting
revesting132814123revesting
revising122714403revis_ing
revisiting1446953revisiting
rifting113515003_rifting
rioting82716393_rioting
rising74025883_ris_ing
risking123914243_risking
roasting93012693roasting
roosting93411453roosting
rousting93913273rousting
rusting83821263_rusting
sainting93215733sainting
seising84018863seis_ing
seriating10916403seriating
shifting152910373shifting
shirting123213603shirting
shitting123212653shitting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sitting83519633_sitting
skirting13289393skirting
skiting123812493ski_ting
slitting93012583slitting
smiting103014443smi_ting
spirting112913633spirting
spiting103917623spi_ting
spitting113012323spitting
stilting93312403stilting
sting65330243___sting
stinting93415743stinting
suiting83419003sui_ting
swishing15277813swishing
tainting93613583tainting
tasting84624213_tasting
testing86021053_testing
thirsting1335283thirsting
tilting83417103_tilting
tinting84620603_tinting
toasting93410573toasting
toiting83217093toi_ting
trusting93411653trusting
trysting12267053trysting
twistings13264353twistings
twitting12307223twitting
uniting8315823uni_ting
vesting114618683_vesting
visaing11279333_visaing
viseing11299163_viseing
vising103915873_vis_ing
visiting1238393_visiting
waistings1352710763waistings
waiting113618953wai_ting
wasting114422843_wasting
westing115020273_westing
whishing18287183whishing
whishting1983563whishting
whisking19286613whisking
whistling1644733whistling
whiting143311303whi_ting
wilting113515913_wilting
wishing144114893_wishing
wising103318223_wis_ing
wisping133711943_wisping
wissing113212943_wissing
witing103522823_wi_ting
witting113417063_witting
worsting1267683worsting
wresting123811833wresting
writing113713893wri_ting
yeasting12188923yeasting
zesting174515333_zesting

Search took 10 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.203880251.2
2DLD Change Limit1461623319.20315882.0
3Display Results3313310.1402364.3
 (SQL Overall)1786913319.54618718.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.