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

131 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
whimsies163519(None) 
whimsied1743111whimsied
flimsies1335782flimsies
hissies103915822_hissies
shimmies15287802shimmies
whammies18265512whammies
whimsey18373892whims_ey
whimseys19322462whimseys
whinnies14237272whinnies
whirlies14167372whirlies
whirries14136692whirries
whishes16309442whi_shes
whiskies1835952whiskies
whities133113252whi_ties
ahimsas1234783ahims_as
bhisties1339003bhisties
chamises153513313chamises
chammies172910163chammies
chemises153211983chemises
chilies124218303chi_lies
chillies134113483chillies
chimblies1845033chimblies
chimeres153511313chimeres
chimes134922573chim__es
chippies17309763chippies
chitties13310773chitties
chivies153412853chi_vies
chivvies1954423chivvies
cissies94116153_cissies
daisies84217093dai_sies
flimsier1344133flimsier
flimsiest1434463flimsiest
ghillies12408663ghillies
gimmies123010113_gimmies
gipsies1039903_gipsies
hickies163614743_hickies
hinnies103615103_hinnies
hippies142813753_hippies
hirsles101510073_hirsles
hisses94719353_hi_sses
hissier103410503_hissier
hissiest112911093_hissiest
homies114524723_hom_ies
hussies103213293_hussies
immies102412443__immies
jimmies18328783_jimmies
khamsins1743393khamsins
missies93423983_missies
phimoses1537203phimoses
phimosis1546193phimosi_s
primsie1137543primsie_
prissies101712003prissies
quinsies1737623quinsies
shammies15259693shammies
shikses14116573shiks_es
shimmied16294983shimmied
shindies122610503shindies
shinnies113010913shinnies
shipsides1544883shipsides
sissies73716603_sissies
slimsier1085213slimsier
slimsiest1135893slimsiest
stimies9316563stim_ies
thimbles1536023thimbles
thirties1139723thirties
weirdies12255783weirdies
whatsis1335253whatsi_s
whatsises1543203whatsises
whatsits1443543whatsits
wheelies1437863wheelies
wherries14179023wherries
whiffles2034263whiffles
whiles124418013whi__les
whimbrel1842433whimbrel
whimbrels1941833whimbrels
whimper17297723whim_per
whimpers18276613whimpers
whims134515333whim___s
whimsical1952233whimsical
whimsy17375223whims__y
whines125120103whi__nes
whinges143610633whi_nges
whinier134110633whi_nier
whiniest14298753whi_niest
whinnied15284153whinnied
whinnier14255003whinnier
whinniest15245133whinniest
whippier18265823whippier
whippiest19265123whippiest
whipsaws1942693whipsaws
whirlier14175293whirlier
whirliest15216043whirliest
whirried15154103whirried
whished17428023whi_shed
whishts16425313whi_shts
whisked18336913whi_sked
whisker17367933whi_sker
whiskers18306773whi_skers
whiskey20445583whi_skey
whiskeys21353383whi_skeys
whisks16497353whi_s_ks
whisper15298013whi_sper
whispers16266993whi_spers
whisted144010013whi_sted
whistles14108213whistles
whists124613813whi_s_ts
whites123919883whi__tes
whitier133311063whi_tier
whitiest14259883whi_tiest
whittles1496673whittles
whizzes2134713whi_zzes
whizzier2233283whizzier
whizziest2342883whizziest
whoopies16267373whoopies
whooshes1734423whooshes
whoosis1335453whoosi_s
whoosises1543423whoosises
whosis1237173wh_osi_s
whosises1435333wh_osises
widdies123514033w_iddies
wienies102213683w_ienies
willies103920153w_illies
wimbles143010853w_imbles
wimpier14248053w_impier
wimpiest1538763w_impiest
wimples143311173w_imples
wises85633193w_i_s_es
wishes124920953w_i_shes
wisses94619603w_i_sses
withies133913543w_ithies
wussies103411083w_ussies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621317.39019778.3
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.85922737.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.