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

124 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
flitching1826534(None) 
fletching18256141fletching
flinching18245831flinching
bitching163610622_bitching
blotching1734962blotching
clinching17276122clinching
clutching17154822clutching
ditching15349942_ditching
faithing1537152fait_hing
fetching17298412f_etching
filching1736112f_ilching
fleeching18305012fleeching
flenching18296702flenching
fletchings19282862fletchings
flicking184110042fli_cking
fliting113514612flit__ing
flitting123010882flit_ting
hitching173310522_hitching
itching134011682__itching
latching143712022_latching
letching143810262_letching
pitching163411112_pitching
snitching1535912snitching
stitching1547102stitching
switching1835702switching
twitching1834242twitching
witching173410632_witching
batching163712093_batching
bewitching2162773bewitching
birching16328463_birching
blanching17297093blanching
bleaching17287093bleaching
blenching17276503blenching
blitzing2035903blit_zing
botching16359703_botching
catching163712773_catching
cinching163310223_cinching
clenching17266303clenching
clicking173610983cli_cking
clothing14278783clot_hing
crutching17216073crutching
etching134511843__etching
farthing1538073fart_hing
filtering13199723filtering
fishing143913863f_i_shing
fitting113516563f_it_ting
flacking184311793fl_acking
flashing153711553fl_ashing
flatling123410013flat_ling
flatting123511253flat_ting
flecking18408233fl_ecking
fleecing14347573fleec_ing
fleshing15339303fl_eshing
flighting1736103flighting
flinging133310053fli_nging
flinting123412343fli_nting
flipping16307663fli_pping
flirting12319013fli_rting
flitch14928173flitch___
flitched17256293flitch_ed
flitches16388463flitch_es
flittering1486503flittering
floccing16306033fl_occing
flocking183410873fl_ocking
flushing15288833fl_ushing
fluting113815093flut__ing
flyting14378553flyt__ing
frenching18267753frenching
fritting123510703frit_ting
frothing15208533frot_hing
glitchier1542793glitchier
glitzing1934973glit_zing
glunching16174083glunching
grutching16224373grutching
hatching173312213_hatching
hotching17309313_hotching
hutching17318643_hutching
inching134414323__inching
itchings14386193__itchings
kithing153411553_kit_hing
kvetching2242903kvetching
lathing114315693_lat_hing
leaching143012833_leaching
leching134613653_l_eching
leeching14318373_leeching
lichting14268513_li_chting
licking144118283_li_cking
litchi1137893_litchi__
litchis1238373_litchi_s
lithoing1236743_lithoing
lunching143110003_lunching
lurching14277333_lurching
lynching17336083_lynching
matching163512393_matching
miching152911803_mi_ching
niching133612433_ni_ching
notching14288583_notching
patching163212753_patching
pinching163711053_pinching
pithing134014053_pit_hing
pleaching17257083pleaching
retching143412173_retching
scotching1735653scotching
scutching1735223scutching
sketching1935083sketching
slicing103514643sli_c_ing
slicking153712593sli_cking
slitting93012583slit_ting
slouching15195723slouching
smirching1744393smirching
smutching1734853smutching
snatching1536363snatching
splotching1842863splotching
thatching1835143thatching
tithing113513893_tit_hing
trithing122811773trit_hing
unflinching2051693unflinching
unhitching1942843unhitching
unlatching1643153unlatching
watching173011173_watching
winching17359903_winching
witchings18325303_witchings
withing143814493_wit_hing
writhing15278673writ_hing

Search took 7 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.420425454.8
2DLD Change Limit1486411246.06324516.1
3Display Results1241240.0631968.3
 (SQL Overall)1786911246.54627297.7
 
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.