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

103 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
whishting198356(None) 
whishing18287181whish_ing
whisting15329541whis_ting
highting16259722_highting
histing113720372_his_ting
waisting123615212wais_ting
weighting1744782weighting
whisking19286612whis_king
whistling1644732whistling
whiting143311302whi__ting
wishing144114892w_ish_ing
wisting113519742w_is_ting
agisting1038243agis_ting
alighting1446413alighting
bighting15269453_bighting
blighting1635733blighting
chiseling1536403chiseling
dighting142510843_dighting
dishing124017103_dish_ing
existing1639073exis_ting
fighting162710083_fighting
fishing143913863_fish_ing
fisting113818123_fis_ting
flighting1736103flighting
foisting122910503fois_ting
frighting1736023frighting
ghosting1336463ghos_ting
hashing145020163_hash_ing
hasting114725193_has_ting
heisting123411043heis_ting
hilting113316893_hi_lting
hinting113919223_hi_nting
hissing114213143_his_sing
hitting113017273_hi_tting
hoisting123610903hois_ting
hosting114318383_hos_ting
hushing144514473_hush_ing
joisting16328503jois_ting
knighting1844443knighting
lichting14268513_lichting
lighting132811833_lighting
listing84020593_lis_ting
misting103623383_mis_ting
pishing134314373_pish_ing
plighting1635563plighting
righting132610853_righting
shifting152910383shi_fting
shirting123213613shi_rting
shitting123212663shi_tting
shushing15317743shush_ing
sighting133110863_sighting
slighting1436373slighting
swishing15277813swish_ing
thirsting1335283thirsting
twisting12427813twis_ting
visiting1238393_visiting
waistings1352710763wais_tings
waiting113618953wai__ting
washing145119283w_ash_ing
wasting114422843w_as_ting
wauchting1843473wauchting
waughting1743123waughting
weighing1635283weigh_ing
welshing15296523welsh_ing
westing115020273w_es_ting
whetting1535973wh_etting
whidding1734573whi_dding
whiffing2134703whi_ffing
whiffling2242883whiffling
whiling143511743whi__ling
whingding1833203whingding
whingeing1733533whingeing
whinging16247743whi_nging
whining143311673whi__ning
whinnying19172733whinnying
whipping19328173whi_pping
whipsawing2251733whipsawing
whirling15237163whi_rling
whirring15286283whi_rring
whirrying1962733whirrying
whisht154510813whisht___
whishted1843153whisht_ed
whishts16425313whisht__s
whispering1944343whispering
whistlings1742913whistlings
whitening1635103whitening
whitewing1943853whitewing
whitings15287063whi__tings
whittling1634383whittling
whizzing2333383whi_zzing
whooshing1943213whoosh_ing
wilting113515913w_i_lting
wising103318223w_is__ing
wisping133711943w_is_ping
wissing113212943w_is_sing
withing143814493w_ith_ing
witing103522823w_i__ting
witting113417063w_i_tting
wooshing1536683woosh_ing
worsting1267683wors_ting
wresting123811833wres_ting
writhing15278673writh_ing
writing113713893wri__ting

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.406440125.6
2DLD Change Limit1486411037.20320636.0
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.65523343.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.