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

114 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
whingding183320(None) 
whingdings1941811whingdings
whingeing1733531whingeing
whinging16247741whing_ing
wingding1436451w_ingding
hinging123917122_hing_ing
shingling14136972shingling
whanging16267142whang_ing
whidding1734572whi_dding
whining143311672whin__ing
whinnying19172732whinnying
winding123517912w_in_ding
wingdings1543682w_ingdings
winging123718712w_ing_ing
wringing13279622wring_ing
binding113819383_bin_ding
bingeing12237643_bingeing
binging113619383_bing_ing
blinding123210163blin_ding
bringing123011273bring_ing
changing153211513chang_ing
chiding143911593chi__ding
childing15288503chi_lding
chining133316843chin__ing
chinking183210893chin_king
chinning14329653chin_ning
clinging122910913cling_ing
cringing123311383cring_ing
dingdong1242433_dingdong
dinging103618613_ding_ing
finding124116543_fin_ding
flinging133310053fling_ing
fringing133010903fring_ing
grinding1139863grin_ding
handing123518893_han_ding
hanging123518703_hang_ing
hiding114319333_hi__ding
higgling14217163_higgling
hilding123713533_hi_lding
hinnying15124853_hinnying
hinting113919223_hin_ting
hongiing1335603_hongiing
ingoing9311023__ingoing
jingling17188573_jingling
kinging133115033_king_ing
minding113317893_min_ding
mingling122010933_mingling
pinging113419553_ping_ing
poinding122510003poin_ding
rehinging1437453rehing_ing
ringing93521283_ring_ing
shending132511253shen_ding
shielding1434553shielding
shindig12244243shin_di_g
shining113816523shin__ing
shinning123211023shin_ning
shinnying16193723shinnying
singeing10209933_singeing
singing93221423_sing_ing
singling101913003_singling
slinging103312863sling_ing
stinging103213453sting_ing
swingeing14144693swingeing
swinging133411113swing_ing
swingling14156203swingling
thinking16289863thin_king
thinning12319093thin_ning
tingeing10198553_tingeing
tinging93619463_ting_ing
tingling102210823_tingling
twingeing14143393twingeing
twinging13278423twing_ing
unhinging1436093unhing_ing
wangling132310993w_angling
weighing1635283wei_ghing
weirding1335593wei_rding
wending123816843w_en_ding
whiffing2134703whi_ffing
whiffling2242883whiffling
whiling143511743whi__ling
whipping19328173whi_pping
whirling15237163whi_rling
whirring15286283whi_rring
whirrying1962733whirrying
whishing18287183whi_shing
whishting1983563whishting
whisking19286613whi_sking
whisting15329543whi_sting
whistling1644733whistling
whitening1635103whitening
whitewing1943853whitewing
whiting143311303whi__ting
whittling1634383whittling
whizzing2333383whi_zzing
wielding13286863w_ielding
wigging133413833w_i_gging
wiggling14217293w_iggling
wilding123814293w_i_lding
winching17359903w_inching
wincing133413903w_in_cing
windings13329973w_in_dings
windling132212263w_indling
wining103625053w_in__ing
winking153317963w_in_king
winkling16298293w_inkling
winning113516553w_in_ning
wintling12249923w_intling
wounding13249403woun_ding
wrangling1456223wrangling
wriggling1533813wriggling
wrinkling17144953wrinkling
wrongdoing1641343wrongdoing
wronging13327393wrong_ing
zinging183513943_zing_ing

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411146.97021325.8
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.17224915.1
 
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.