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

120 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
whishted184315(None) 
whished17428021whish_ed
whisted144010011whis_ted
highted152710162_highted
histed104420242_his_ted
waisted114210942wais_ted
weighted1635592weighted
whishes16309442whish_es
whisht154510812whisht__
whishts16425312whisht_s
whisked18336912whis_ked
whistled1595782whistled
whited134814082whi__ted
wished134417512w_ish_ed
wisted104120272w_is_ted
agisted938203agis_ted
alighted1347673alighted
bighted142810923_bighted
blighted1546863blighted
chested133811673ches_ted
chiseled1435883chiseled
cisted95217523_cis_ted
dighted132511493_dighted
dished114318713_dish_ed
existed1538473exis_ted
fished134316313_fish_ed
fisted104218703_fis_ted
flighted1646973flighted
foisted113210603fois_ted
frighted1657173frighted
ghosted1236273ghos_ted
hashed136021943_hash_ed
hasted105125283_has_ted
heisted113210653heis_ted
hilted104016043_hi_lted
hinted104318323_hi_nted
hissed104114453_his_sed
hoisted113411293hois_ted
hosted105020343_hos_ted
hushed134416673_hush_ed
joisted15379173jois_ted
knighted1745123knighted
lichted13268803_lichted
lighted122913503_lighted
listed74322833_lis_ted
misted93625823_mis_ted
pished124817063_pish_ed
plighted1546463plighted
righted122912143_righted
shifted14359983shi_fted
shitted114212053shi_tted
shushed14348493shush_ed
sighted123111523_sighted
slighted1357393slighted
swished14418843swish_ed
thighed1535273thigh_ed
thirsted1235213thirsted
twisted11277433twis_ted
visited1168773_visited
waister103812383wais_ter
waited103819773wai__ted
washed135521503w_ash_ed
wasted104423023w_as_ted
wauchted1753373wauchted
waughted1643483waughted
weighed15135933weigh_ed
weighter1535603weighter
welshed14277203welsh_ed
whetted14256693wh_etted
whidded1634423whi_dded
whiffed2064473whi_ffed
whiffled2133043whiffled
whiled134514133whi__led
whimsied1743113whimsied
whined134715203whi__ned
whinged15409153whi_nged
whinnied15284153whinnied
whipped18379333whi_pped
whipsawed2141853whipsawed
whirled14368043whi_rled
whirred14386933whi_rred
whirried15154103whirried
whish144512923whish___
whishing18287183whishing
whishting1983563whishting
whisker17367933whis_ker
whiskered20123393whiskered
whiskey20445583whis_key
whiskies1835953whiskies
whisper15298013whis_per
whispered18144373whispered
whist115322953whis_t__
whistle13107533whis_tle
whistler1496313whistler
whistles14108213whistles
whists124613813whis_t_s
white114920303whi__te_
whiten124111923whi__ten
whitened1535173whitened
whiter124316393whi__ter
whites123919883whi__tes
whitey154911883whi__tey
whither163510253whith_er
whitter139110893whi_tter
whittled1594913whittled
whizzed2234063whi_zzed
whooshed1833453whoosh_ed
wilted103915713w_i_lted
wised95123343w_is__ed
wisher123617063w_ish_er
wishes124920953w_ish_es
wisped123411893w_is_ped
wissed104114643w_is_sed
wited94727143w_i__ted
withed134416233w_ith_ed
witted104216813w_i_tted
wooshed14167403woosh_ed
worsted1138013wors_ted
wrested113410933wres_ted
writhed14389623writh_ed

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621206.20323563.1
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.68926714.2
 
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.