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

261 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
flitches1638846(None) 
fitches153516191f_itches
fletches16308851fletches
flinches16358951flinches
flitched17256291flitched
glitches14296651glitches
aitches123014362_aitches
bitches144117062_bitches
blotches1537432blotches
britches15278682britches
cliches144213742cli_ches
clinches153910362clinches
clutches15307922clutches
ditches133215712_ditches
fetches153413892f_etches
fetiches1636952fetiches
fiches145219532f_i_ches
filches153410722f_ilches
finches153914192f_inches
fitchee152710782f_itchee
fitchet153113562f_itchet
fitchets16307412f_itchets
fitchew18276802f_itchew
fitchews19274772f_itchews
fleches153411442fl_eches
fleeches16287082fleeches
flenches163410532flenches
fletched17306692fletched
fletcher16306662fletcher
fletchers17335532fletchers
flinched17316702flinched
flincher16256582flincher
flinchers17295472flinchers
flitch14928172flitch__
flites95122442flit__es
flysches1933122flysches
hitches153616272_hitches
itches114916212__itches
klatches17157132klatches
latches123320122_latches
letches124015482_letches
liches114724292_li_ches
litchis1238372_litchis
pitches143617752_pitches
quitches2236192quitches
slatches131511522slatches
snitches13148982snitches
stitches131410592stitches
switches16159132switches
twitches16156372twitches
witches152715792_witches
affiches1945233affi_ches
batches144019613_batches
bewitches1943823bewitches
birches143412323_birches
bitched153212923_bitched
bitchen14349733_bitchen
blanches153311603blanches
bleaches153410673bleaches
blenches153310763blenches
blites84721213blit__es
blithe115810863blit_he_
blither124812173blit_her
blithers134711233blit_hers
blithest1338083blit_hest
blitzes18408703blit_zes
blotched1635653blotched
botches143716023_botches
brioches15227253brioches
butches144315363_butches
caliches153812263cali_ches
catches144320773_catches
chinches18369363chinches
cinches144215773_cinches
clenches152910953clenches
cliche133712453cli_che_
cliched153711023cli_ched
clinched16347383clinched
clincher15347663clincher
clinchers16336263clinchers
cloches144113713cl_oches
clothes124513813clot_hes
clutched16356033clutched
cratches153012543cratches
crotches153411303crotches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
ditched143711903_ditched
ditcher134012003_ditcher
ditchers143610363_ditchers
elites66027123elit__es
etches114217763__etches
faithed1437163fait_hed
faiths124610273fait_h_s
fetched163710473f_etched
fetcher153510393f_etcher
fetchers16328863f_etchers
fetishes1437153fetishes
fiacres1237253f_iacres
fices106031163f_i_c_es
fiche134616743f_i_che_
fichus14388113f_i_chus
ficoes114613463f_i_coes
filched16307423f_ilched
filcher15377793f_ilcher
filchers16286863f_ilchers
filths12389783filt_h_s
fishes125221343f_i_shes
fitch134816873f_itch__
fitchy17437623f_itch_y
flashes133916103fl_ashes
flatcaps1563403flatcaps
flatcars1344623flatcars
flatuses1137173flatuses
fleche14299303fl_eche_
fleeces12399643fleec_es
fleeched17345823fleeched
flenched17267963flenched
fleshes133913273fl_eshes
fletch14388193fletch__
flichter1664963fli_chter
flichters1774173fli_chters
flicked174610673fli_cked
flicker163610623fli_cker
flickers17338883fli_ckers
flicks154512993fli_c_ks
flics105418363fli_c__s
flies85630713fli___es
flights143310983fli_ghts
flimsies1335783flimsies
flinch144010103flinch__
flitching18265343flitching
flite85424963flit__e_
flited104616583flit__ed
flits85625223flit___s
flitted114011643flit_ted
flitter103413903flit_ter
flitters114312173flitters
flotages1237163flotages
flushes134114143fl_ushes
flutes95421783flut__es
flytes123911563flyt__es
frenches163311633frenches
frites94922483frit__es
friths124313583frit_h_s
fritzes19329453frit_zes
glitch12286353glitch__
glitchier1542793glitchier
glitchiest1642793glitchiest
glitchy16283083glitch_y
glitzes17367563glit_zes
glunches1436263glunches
grinches1436943grinches
grutches14285853grutches
hatches153420273_hatches
hitched163312253_hitched
hitcher153712003_hitcher
hitchers16379993_hitchers
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inches114419673__inches
itched123812023__itched
ketches164012193_ketches
kitchen16287683_kitchen
kitchens17195783_kitchens
kithes135016653_kit_hes
kitsches1734073_kitsches
klatsches1842223klatsches
kvetches2053583kvetches
laches116528343_l_aches
larches124416443_larches
latched133914063_latched
latchet123117903_latchet
latchets133410013_latchets
lathes95127493_lat_hes
leaches123319343_leaches
leches115421313_l_eches
leeches123911933_leeches
letched133912053_letched
lethes94818083_let_hes
lichee114017973_li_chee
lichees123512783_li_chees
lichen114012743_li_chen
lichens123510683_li_chens
lichis115212593_li_chis
lichts113712383_li_chts
litchi1137893_litch_i
lithe84922013_lit_he_
lither94520953_lit_her
lithest10513913_lit_hest
lithos94212553_lit_hos
litotes7311183_litotes
litres65220393_lit_res
littles73212783_littles
loaches123613983_loaches
lunches124115443_lunches
lurches123311663_lurches
lyches144213613_l_yches
lynches15378873_lynches
matches143219783_matches
miches134320733_mi_ches
mutches143314283_mutches
nautches1336083nautches
niches114419143_ni_ches
nitchies1339073_nitchies
notches123513653_notches
painches1588913painches
patches143320383_patches
pinches144117933_pinches
pitched153512923_pitched
pitcher143813713_pitcher
pitchers153211483_pitchers
planches153111863planches
pleaches153210433pleaches
plenches153110623plenches
potiches1539203potiches
quiches2139333qui_ches
ratches123620463_ratches
retches123318513_retches
riches115022083_ri_ches
rotches123515703_rotches
scotches15179473scotches
scutches15168883scutches
seiches12513813sei_ches
sketches1746823sketches
slices84022853sli_c_es
slither104112983slit_her
slithers114212953slit_hers
slouches13208073slouches
smirches1535993smirches
smutches15177273smutches
snatches131410713snatches
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
splotches1643913splotches
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
swatches16169963swatches
switched17157133switched
switcher16177683switcher
switchers17146633switchers
thatches1637513thatches
tithes94720213_tit_hes
twitched17155033twitched
twitcher16135343twitcher
twitchers17134533twitchers
unhitches1743073unhitches
unlatches1444293unlatches
vetches153411263_vetches
watches153017373_watches
wiches144418753_wi_ches
winches154714373_winches
witched163012193_witched
withes124620843_wit_hes
wretches16257283wretches
writhes134811703writ_hes
zilches21326303_zilches

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622617.08020644.4
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.57623586.5
 
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.