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

176 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
smirches153599(None) 
smirched1634671smirched
besmirches1982162besmirches
birches143412322_birches
marches143921172_marches
merches144013762_merches
miches134320732_mi_ches
scorches15189142scorches
searches132112902searches
seiches12513812sei_ches
smirch1356462smirch__
smooches15217262smooches
smutches15177272smutches
snitches13148982snitches
starches131912912starches
stitches131410592stitches
switches16159132switches
aitches123014363_aitches
amerces1149853amerc_es
amices105018013ami_c_es
amirates101114793amirates
arches114822043__arches
besmirched2051933besmirched
birched15349913_birched
birchen14347883_birchen
bitches144117063_bitches
brioches15227253brioches
britches15278683britches
chinches18369363chinches
churches1846433churches
cinches144215773_cinches
circles1139903_circles
cliches144213743cli_ches
clinches153910363clinches
curches143512743_curches
demarches1745913demarches
ditches133215713_ditches
emirates101214853emirates
enriches1337263enriches
fiches145219533_fi_ches
filches153410723_filches
finches153914193_finches
fitches153516193_fitches
flinches16358953flinches
flitches16388463flitches
girshes11248293_girshes
glitches14296653glitches
grinches1436943grinches
hitches153616273_hitches
inarches1358043inarches
inches114419673__inches
itches114916213__itches
kirsches1743843_kirsches
larches124416443_larches
liches114724293_li_ches
lurches123311663_lurches
maches134827233_m_aches
manches143818623_manches
marched153813403_marched
marchen143312073_marchen
marcher143912973_marcher
marchers153710813_marchers
marchesa15346883_marchesa
marchese15358913_marchese
marchesi15337323_marchesi
marshes123615373_marshes
matches143219783_matches
merces105720743_merc_es
mercies113817563_mercies
miche126219243_mi_che_
miched143913393_mi_ched
minces104420803_minc_es
miracles1238333_miracles
mirages102213533_mirages
mires75640883_mir__es
mirexes1636993_mirexes
mirths114912993_mirth_s
miscues11312393_miscues
mooches143714453_mooches
mouches143815963_mouches
muches134718993_m_uches
mulches143210673_mulches
munches144215793_munches
mutches143314283_mutches
niches114419143_ni_ches
ostriches1446633ostriches
painches1588913painches
parches143720003_parches
perches143717953_perches
pinches144117933_pinches
pitches143617753_pitches
porches143815673_porches
quiches2139333qui_ches
quitches2236193quitches
riches115022083_ri_ches
saices84221803sai_c_es
scirrhus1342003scirrhus
scooches15188413scooches
scorched16187193scorched
scorcher15196783scorcher
scorchers16145513scorchers
scotches15179473scotches
sculches15176273sculches
scutches15168883scutches
searched14209253searched
searcher13209103searcher
searchers14197353searchers
seiche11811833sei_che_
seviches1635803seviches
shires95225573shir__es
sices75637273s_i_c_es
sirees64624583s_ir_ees
sires55945373s_ir__es
sirrees73410563s_irrees
sketches1746823sketches
slatches131511523slatches
slices84022853sli_c_es
slouches13208073slouches
smarties10312873smarties
smashes123914613sm_ashes
smidges11448193smi_dges
smiercase1342753smiercase
smiercases1443293smiercases
smilaxes1744653smilaxes
smiles84522293smi__les
smirching1744393smirching
smirked14307233smir_ked
smirker13327423smir_ker
smirkers14316353smirkers
smirkier1444433smirkier
smirkiest1535193smirkiest
smirks124910123smir__ks
smites83921923smi__tes
smithers13369793smi_thers
smithies1337913smithies
smiths114711023smi_th_s
smooched16185983smooched
smoocher15205503smoocher
smoochers16184833smoochers
smooshes13206863smooshes
smoothes13218533smoothes
smushes123710093sm_ushes
smutched16165923smutched
snatches131410713snatches
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
soirees72411643soir_ees
soroches1338803soroches
sources9312173sourc_es
speeches1537413speeches
spices104326033spi_c_es
spinaches1645273spinaches
spiracles1345663spiracles
spiremes12397623spiremes
spires84628113spir__es
squinches2344253squinches
stanches132312793stanches
starched14199313starched
stenches132110293stenches
stichs114511653sti_ch_s
stirpes95011293stir_pes
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
swatches16169963swatches
swishes133411373swi_shes
switched17157133switched
switcher16177683switcher
switchers17146633switchers
torches123715433_torches
twitches16156373twitches
wiches144418753_wi_ches
winches154714373_winches
witches152715793_witches
zilches21326303_zilches

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621768.03318195.2
3Display Results1761760.0602933.3
 (SQL Overall)1786911768.24921662.1
 
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.