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

152 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
whittling163438(None) 
whistling1644731whistling
whittlings1742221whittlings
brittling1235542brittling
chitling142910662chi_tling
cuittling1234102cuittling
hitting113017272_hitt_ing
kittling1336062_kittling
shitting123212662shitt_ing
shuttling1334292shuttling
vittling1236142_vittling
wattling12258782w_attling
whetting1535972whett_ing
whiffling2242882whiffling
whiling143511742whi__ling
whirling15237162whi_rling
whisting15329542whist_ing
whistlings1742912whistlings
whitening1635102whitening
whitewing1943852whitewing
whiting143311302whi_t_ing
wintling12249922w_intling
witling113215812w_i_tling
witting113417062w_itt_ing
battling113110493_battling
belittling1343193belittling
bitting103717293_bitt_ing
bottling11279143_bottling
brattling1236003brattling
bristling1246663bristling
chatting142810143chatt_ing
chilling143512183chi_lling
chiseling1536403chiseling
chitlin12269283chi_tlin_
chitlings15255903chi_tlings
chitlins13289393chi_tlins
chittering16107183chittering
chortling1535563chortling
cuttling1138203_cuttling
dittoing1036263_dittoing
emitting112410353emitt_ing
entitling1037103entitling
fettling1266773_fettling
fitting113516563_fitt_ing
flitting123010883flitt_ing
fritting123510703fritt_ing
ghettoing1442123ghettoing
gitting93215703_gitt_ing
gritting10309983gritt_ing
guttling1037293_guttling
hatting113920233_hatt_ing
higgling14217163_higgling
hilling113821773_hi_lling
hilting113316893_hilt_ing
hinting113919223_hint_ing
hireling121210993_hireling
hirpling1467223_hirpling
hirsling1277543_hirsling
histing113720373_hist_ing
hitching173310523_hitching
hotting113116523_hott_ing
hurtling12318313_hurtling
hustling12228793_hustling
hutting113016033_hutt_ing
intitling1037213intitling
kitling123313573_ki_tling
kitting123214443_kitt_ing
knitting13257023knitt_ing
mottling11197753_mottling
nettling957213_nettling
omitting11217743omitt_ing
pettling1168213_pettling
philtring1544173philtring
pitting103618873_pitt_ing
prattling1246303prattling
quitting18228833quitt_ing
rattling92510873_rattling
retitling1039773retitling
scuttling1234243scuttling
settling978943_settling
shieling123512403shi_eling
shifting152910383shift_ing
shilling123315383shi_lling
shingling14136973shingling
shirting123213613shirt_ing
shotting123012383shott_ing
shutting12309693shutt_ing
sitting83519633_sitt_ing
slitting93012583slitt_ing
spitting113012323spitt_ing
tattling9259473_tattling
thirling12248583thi_rling
throttling1442793throttling
titling83715793_ti_tling
twattling1332693twattling
twitting12307223twitt_ing
wailing113620903wai__ling
waisting123615213waist_ing
waistline1244173waistline
waitering13310713waitering
waiting113618953wai_t_ing
warstling1335063warstling
wetting114117383w_ett_ing
whaling143910773wh__aling
wheedling1733073wheedling
wheeling15318593wh_eeling
wheepling1843323wheepling
whidding1734573whi_dding
whiffing2134703whi_ffing
whingding1833203whingding
whingeing1733533whingeing
whinging16247743whi_nging
whining143311673whi__ning
whinnying19172733whinnying
whipping19328173whi_pping
whirring15286283whi_rring
whirrying1962733whirrying
whishing18287183whi_shing
whishting1983563whishting
whisking19286613whi_sking
whitenings1742613whitenings
whitewings2042333whitewings
whitings15287063whi_t_ings
whittle13106103whittl__e
whittled1594913whittl_ed
whittler1495193whittl_er
whittlers1594333whittlers
whittles1496673whittl_es
whizzing2333383whi_zzing
widdling14228743w_iddling
wiggling14217293w_iggling
wildling13248083w_ildling
wiling103024293w_i__ling
willing113821613w_i_lling
wilting113515913w_ilt_ing
wimbling16186543w_imbling
wimpling16207483w_impling
windling132212263w_indling
winkling16298293w_inkling
wisting113519743w_ist_ing
witching173410633w_itching
withing143814493w_i_thing
witing103522823w_i_t_ing
witlings12328443w_i_tlings
wittings12328733w_itt_ings
wotting112913843w_ott_ing
wrastling1335523wrastling
wrestling1336063wrestling
wriggling1533813wriggling
wrinkling17144953wrinkling
writhing15278673wri_thing
writing113713893wri_t_ing

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 Limit1486411526.47022973.9
3Display Results1521520.0602533.3
 (SQL Overall)1786911526.95025710.9
 
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.