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 “whitewing” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
whitewing194385(None) 
whitening1635101whitening
whitewings2042331whitewings
bitewing1435292_bitewing
waitering13310722waitering
whitenings1742612whitenings
whiting143311302whit__ing
whittling1634382whittling
bitewings1542943_bitewings
chewing163911143ch__ewing
chiseling1536403chiseling
chitling142910663chit_ling
chittering16107183chittering
hewing134514243_h__ewing
hieing104216623_hi_e_ing
hireling121210993_hireling
hitching173310523_hitching
hitting113017273_hit_ting
iteming1037753__iteming
loitering1039683loitering
mitering113015403_mitering
philtering1646253philtering
shewing143812193sh__ewing
shieling123512403shi_eling
shitting123212663shit_ting
shivering1637333shivering
shrewing15228093sh_rewing
sinewing1267593_sinewing
stewing113412493__stewing
tewing103914823___tewing
thieving1535143thi_eving
viewing1437073_vi_ewing
waiting113618953wait__ing
watering122316323w_atering
weltering13219493weltering
westering132112643westering
wheeling15318603wh_eeling
wheeping17337103wh_eeping
wheezing24315383wh_eezing
whetting1535973whet_ting
whickering2343413whickering
whidding1734573whi_dding
whiffing2134703whi_ffing
whiffling2242883whiffling
whiling143511743whi__ling
whimpering2143853whimpering
whingding1833203whingding
whingeing1733533whingeing
whinging16247743whi_nging
whining143311673whi__ning
whinnying19172733whinnying
whipping19328173whi_pping
whipsawing2251733whipsawing
whirling15237163whi_rling
whirlwind1941513whirlwind
whirring15286283whi_rring
whirrying1962733whirrying
whishing18287183whi_shing
whishting1983563whishting
whisking19286613whi_sking
whispering1944343whispering
whisting15329543whi_sting
whistling1644733whistling
whitefish2143073whitefish
whiten124111923white__n_
whitens13428733white__ns
whitewall1852783whitewall
whitewash2152703whitewash
whitewashing2561023whitewashing
whitewood1953223whitewood
whitings15287063whit__ings
whittlings1742223whittlings
whizzing2333383whi_zzing
widening13237833w_idening
widowing1635183w_idowing
wintering13412363wintering
witching173410633w_itching
withering16108813w_ithering
withing143814493w_it_hing
witing103522823w_it__ing
witling113215813w_it_ling
witting113417063w_it_ting
wizening21255463w_izening
writhing15278673writ_hing
writing113713893writ__ing

Search took 9 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.440406115.9
2DLD Change Limit148641858.45317584.4
3Display Results85850.0302833.3
 (SQL Overall)178691858.92320025.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.