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

151 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
whimsey1837389(None) 
whimseys19322461whimseys
whimsy17375221whims_y
chimley1785162chimley
chimney1795482chimney
whimper17297722whimper
whims134515332whims__
whimsied1743112whimsied
whimsies1635192whimsies
whiney155012642whi_ney
whiskey20445582whiskey
whisky19455902whi_sky
whitey154911882whi_tey
ahimsa1134783ahims_a
ahimsas1234783ahimsas
blimey13468453blim_ey
chimbley2063133chimbley
chimbly1974593chimbly
chime125322593chim_e_
chimed145814833chim_ed
chimer135517203chim_er
chimes134922573chim_es
chimleys1883633chimleys
chimneys1883643chimneys
chisel112111943chi_sel
choosey15459233choosey
flimsy14345563flims_y
hickey185011993_hickey
hims95230973_hims__
himself1544283_himself
hirsel9138683_hirsel
hissed104114453_hissed
hisser94713793_hisser
hisses94719353_hisses
hissy116112123_hi_ssy
homey135924843_hom_ey
horsey125115403_horsey
hosey116127023_h_osey
limey104721043_lim_ey
limpsey14365093_limpsey
linsey938993_linsey
malmsey1433623malmsey
phimoses1537203phimoses
shikse1386073shikse_
shikseh17102603shikseh
shikses14116573shikses
shimmed15338583shimmed
shimmer143310873shimmer
shimmery18265253shimmery
shimmy16306413shim_my
shims104422553shims__
shinney13368293shinney
slimsy11407723slims_y
thirsty1354083thirsty
thymey17426313thym_ey
whammed18345133whammed
whammy19375293wham_my
whams135515643whams__
whey135018713wh___ey
wheyey1834323wh_eyey
whicker19359773whicker
whidded1634423whidded
whids125413983whids__
whiffed2064473whiffed
whiffer19105323whiffer
whiffet1965343whiffet
whigs125612643whigs__
while115418693whi_le_
whiled134514133whi_led
whiles124418013whi_les
whilst1239143whils_t
whim126220533whim___
whimbrel1842433whimbrel
whimpers18276613whimpers
whine116022813whi_ne_
whined134715203whi_ned
whiner124516633whi_ner
whines125120103whi_nes
whinge134311543whinge_
whinged15409153whinged
whinger1410810913whinger
whinges143610633whinges
whinier134110633whinier
whinny15587493whi_nny
whins114922333whins__
whiny144915573whi__ny
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
whippy19385843whi_ppy
whipray1843403whipray
whips134917083whips__
whipsaw1842723whipsaw
whirled14368043whirled
whirler13307603whirler
whirly15448863whi_rly
whirred14386933whirred
whirry15477063whi_rry
whirs115218093whirs__
whish144512923whi_s_h
whished17428023whished
whishes16309443whishes
whisht154510813whi_sht
whisk154510143whi_s_k
whisked18336913whisked
whisker17367933whisker
whiskery21314553whiskery
whiskeys21353383whiskeys
whisks16497353whi_sks
whisper15298013whisper
whispery19284293whispery
whist115322953whi_s_t
whisted144010013whisted
whists124613813whi_sts
white114920303whi_te_
whited134814083whi_ted
whitely16346473whitely
whiten124111923whi_ten
whiter124316393whi_ter
whites123919883whi_tes
whitest133710113whitest
whiteys16396153whi_teys
whither163510253whither
whitier133311063whitier
whities133113253whities
whits115923823whits__
whitter139110893whitter
whity145513473whi__ty
whizzed2234063whizzed
whizzer2134583whizzer
whizzes2134713whizzes
whizzy23274073whi_zzy
whomped18345473whomped
whomso1434133whoms_o
whose114914533wh_ose_
whumped18335633whumped
wifey144913673w_i_fey
wimped144211513w_imped
wimpy155911923w_im_py
wincey144110383w_incey
winey115325433w_i_ney
wise75737343w_i_se_
wised95123343w_i_sed
wisely122711713w_i_sely
wiser85522803w_i_ser
wises85633193w_i_ses
wispy137210973w_i_spy
wissed104114643w_issed
wisses94619603w_isses
witney12356843w_itney
wristy12509703wri_sty

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271516.62620227.4
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.82526181.8
 
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.