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

148 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
whistling164473(None) 
whisting15329541whist_ing
whistlings1742911whistlings
whittling1634381whittling
bristling1246662bristling
chiseling1536402chiseling
chitling142910662chi_tling
histing113720372_hist_ing
hustling12228792_hustling
waisting123615212waist_ing
waistline1244172waistline
warstling1335062warstling
whiffling2242882whiffling
whiling143511742whi__ling
whirling15237162whi_rling
whishing18287182whis_hing
whishting1983562whishting
whisking19286612whis_king
whiting143311302whi_t_ing
whittlings1742222whittlings
wintling12249922w_intling
wisting113519742w_ist_ing
witling113215812w_i_tling
wrastling1335522wrastling
wrestling1336062wrestling
agisting1038243agist_ing
brisling112410843bris_ling
brittling1235543brittling
bustling112110063_bustling
castling11311233_castling
chilling143512183chi_lling
chiselling1644683chiselling
chitlin12269283chi_tlin_
chitlings15255903chi_tlings
chitlins13289393chi_tlins
chortling1535563chortling
cuittling1234103cuittling
enisling949633enis_ling
existing1639073exist_ing
firstling1334423firstling
fisting113818123_fist_ing
foisting122910503foist_ing
ghosting1336463ghost_ing
hassling1236803_hassling
hasting114725193_hast_ing
heisting123411043heist_ing
higgling14217163_higgling
hilling113821773_hi_lling
hilting113316893_hilt_ing
hinting113919223_hint_ing
hireling121210993_hireling
hirpling1467223_hirpling
hirseling1396273_hirseling
hirsling1277543_hirsling
hissing114213143_his_sing
hitting113017273_hi_tting
hoisting123610903hoist_ing
hosteling1337893_hosteling
hosting114318383_host_ing
hurtling12318313_hurtling
isling71213883__is_ling
joisting16328503joist_ing
jostling16207123_jostling
justling16207253_justling
kitling123313573_ki_tling
kittling1336063_kittling
listing84020593_list_ing
misting103623383_mist_ing
nestling958893_nestling
pestling111010253_pestling
philtring1544173philtring
pistoling1268493_pistoling
quisling18218063quis_ling
rustling9249983_rustling
shieling123512403shi_eling
shifting152910383shift_ing
shilling123315383shi_lling
shingling14136973shingling
shirting123213613shirt_ing
shitting123212663shi_tting
shuttling1334293shuttling
thirling12248583thi_rling
thirsting1335283thirst_ing
thistlier1243653thistlier
titling83715793_ti_tling
twisting12427813twist_ing
vittling1236143_vittling
wailing113620903wai__ling
waistings1352710763waist_ings
waistlines1343893waistlines
waiting113618953wai_t_ing
warsling12198593wars_ling
wasting114422843w_ast_ing
wattling12258783w_attling
weaseling1335613weaseling
westing115020273w_est_ing
whaling143910773wh__aling
wheedling1733073wheedling
wheeling15318593wh_eeling
wheepling1843323wheepling
whetting1535973wh_etting
whidding1734573whi_dding
whiffing2134703whi_ffing
whingding1833203whingding
whingeing1733533whingeing
whinging16247743whi_nging
whining143311673whi__ning
whinnying19172733whinnying
whipping19328173whi_pping
whipsawing2251733whipsawing
whirring15286283whi_rring
whirrying1962733whirrying
whispering1944343whispering
whistle13107533whistl__e
whistled1595783whistl_ed
whistler1496313whistl_er
whistlers1595163whistlers
whistles14108213whistl_es
whitening1635103whitening
whitewing1943853whitewing
whitings15287063whi_t_ings
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
wishing144114893w_is_hing
wising103318223w_is__ing
wisping133711943w_is_ping
wissing113212943w_is_sing
withing143814493w_i_thing
witing103522823w_i_t_ing
witlings12328443w_i_tlings
witting113417063w_i_tting
worsting1267683worst_ing
wrassling1334273wrassling
wresting123811833wrest_ing
wrestlings1442933wrestlings
wriggling1533813wriggling
wrinkling17144953wrinkling
writhing15278673wri_thing
writing113713893wri_t_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.423422437.4
2DLD Change Limit1486411487.36020195.8
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.84322783.5
 
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.