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

136 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
fletching1825614(None) 
fetching17298411f_etching
fleeching18305011fleeching
flenching18296701flenching
fletchings19282861fletchings
flitching18265341flitching
letching143810261_letching
bleaching17287092bleaching
blenching17276502blenching
blotching1734962blotching
clenching17266302clenching
clutching17154822clutching
etching134511842__etching
flecking18408232fle_cking
fleecing14347572fleec_ing
fleshing15339302fle_shing
flinching18245832flinching
frenching18267752frenching
kvetching2242902kvetching
latching143712022_latching
leaching143012832_leaching
leching134613652_le_ching
leeching14318372_leeching
pleaching17257082pleaching
retching143412172_retching
sketching1935082sketching
batching163712093_batching
beaching164114143_beaching
belching16349153_belching
benching163411343_benching
bitching163610623_bitching
blanching17297093blanching
botching16359703_botching
breaching17269403breaching
breeching17236473breeching
catching163712773_catching
clinching17276123clinching
clothing14278783clot_hing
crutching17216073crutching
detaching1637263_detaching
ditching15349943_ditching
drenching16256033drenching
eching126315563__e_ching
electing112113783ele_cting
etchings14396293__etchings
faithing1537153fait_hing
farthing1538073fart_hing
felting113515213felt__ing
fencing132411133f_enc_ing
fetchingly2242723f_etchingly
feting104417793f_et__ing
fetting113517873f_et_ting
fettling1266773f_ettling
filching1736113f_ilching
fileting1239303filet__ing
flacking184311793fl_acking
flashing153711553fl_ashing
flatling123410013flat_ling
flatting123511253flat_ting
fledging14276523fle_dging
fledgling1552473fledgling
fleeing113511293fle__eing
fleering123811283fle_ering
fleeting122910323fle_eting
fleishig1542893fleishi_g
flemishing1943493flemishing
flensing1246973fle_nsing
fleshings16335383fle_shings
fletch14388193fletch___
fletched17306693fletch_ed
fletcher16306663fletch_er
fletchers17335533fletchers
fletches16308853fletch_es
flexing18358993fle__xing
fleying14329873fle__ying
flicking184110043fl_icking
fliting113514613flit__ing
flitting123010883flit_ting
floccing16306033fl_occing
flocking183410873fl_ocking
flushing15288833fl_ushing
fluting113815093flut__ing
flyting14378553flyt__ing
frescoing1544683frescoing
freshing152611023fre_shing
fretting122711523fret_ting
frothing15208533frot_hing
glunching16174083glunching
grutching16224373grutching
hatching173312213_hatching
hitching173310523_hitching
hotching17309313_hotching
hutching17318643_hutching
itching134011683__itching
lathing114315693_lat_hing
leashing123310313_leashing
letting83218533_let_ting
lunching143110003_lunching
lurching14277333_lurching
lynching17336083_lynching
matching163512393_matching
naething1236073naet_hing
notching14288583_notching
patching163212753_patching
peaching163613643_peaching
peching154513903_pe_ching
perching163711633_perching
pitching163411113_pitching
preaching172811163preaching
quenching2443923quenching
reaching143317203_reaching
scotching1735653scotching
scutching1735223scutching
seething1239023seet_hing
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
splotching1842863splotching
stitching1547103stitching
stretching1645813stretching
switching1835703switching
teaching143612603_teaching
teething1237163teet_hing
thatching1835143thatching
trenching15227653trenching
twitching1834243twitching
unlatching1643153unlatching
vetchling1843593_vetchling
watching173011173_watching
welching17287363_welching
wenching17328863_wenching
witching173410633_witching
wrenching18276273wrenching

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.423422437.4
2DLD Change Limit1486411366.23323847.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.70226662.3
 
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.