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

97 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
whiffling224288(None) 
whiffing2134701whiff_ing
piffling1745132_piffling
riffling1556112_riffling
shuffling1933452shuffling
skiffling2043102skiffling
sniffling1644092sniffling
waffling1845422w_affling
whiling143511742whi__ling
whirling15237162whi_rling
whistling1644732whistling
whittling1634382whittling
baffling1756053_baffling
biffing163510013_biff_ing
chaffing2036323chaff_ing
cheffing2034463cheff_ing
chilling143512183chi_lling
chiseling1536403chiseling
chitling142910663chi_tling
chuffing2055043chuff_ing
coffling1736483_coffling
coiffing1755933coiff_ing
higgling14217163_higgling
hilling113821773_hi_lling
hireling121210993_hireling
hirpling1467223_hirpling
hirsling1277543_hirsling
huffing17278833_huff_ing
miffing16298403_miff_ing
muffling1765503_muffling
raffling1567063_raffling
riffing144011273_riff_ing
rifling112815013_ri_fling
ruffling1546093_ruffling
scuffling1843613scuffling
shieling123512403shi_eling
shifting152910383shi_fting
shilling123315383shi_lling
shingling14136973shingling
snaffling1643763snaffling
sniffing15227453sniff_ing
snuffling1643563snuffling
spiffing17237083spiff_ing
spiffying2142753spiffying
stiffing15248703stiff_ing
stifling122110913sti_fling
thirling12248583thi_rling
tiffing14339383_tiff_ing
trifling122411503tri_fling
waffing173710243w_aff_ing
wafflings1943023w_afflings
waifing142910893wai_f_ing
wailing113620903wai__ling
whaling143910773wh__aling
wharfing1834683wharf_ing
wheedling1733073wheedling
wheeling15318593wh_eeling
wheepling1843323wheepling
whidding1734573whi_dding
whiffle1933533whiffl__e
whiffled2133043whiffl_ed
whiffler2033483whiffl_er
whifflers2142773whifflers
whiffles2034263whiffl_es
whingding1833203whingding
whingeing1733533whingeing
whinging16247743whi_nging
whining143311673whi__ning
whinnying19172733whinnying
whipping19328173whi_pping
whirring15286283whi_rring
whirrying1962733whirrying
whishing18287183whi_shing
whishting1983563whishting
whisking19286613whi_sking
whisting15329543whi_sting
whistlings1742913whistlings
whitening1635103whitening
whitewing1943853whitewing
whiting143311303whi__ting
whittlings1742223whittlings
whizzing2333383whi_zzing
whoofing18234833whoof_ing
widdling14228743w_iddling
wifing133513393w_i_f_ing
wiggling14217293w_iggling
wildling13248083w_ildling
wiling103024293w_i__ling
willing113821613w_i_lling
wimbling16186543w_imbling
wimpling16207483w_impling
windling132212263w_indling
winkling16298293w_inkling
wintling12249923w_intling
witling113215813w_i_tling
wriggling1533813wriggling
wrinkling17144953wrinkling

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 Limit148641976.21623912.6
3Display Results97970.0462108.7
 (SQL Overall)178691976.68526730.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.