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 “whimseys” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
whimseys1932246(None) 
whimsey18373891whimsey_
chimleys1883632chimleys
chimneys1883642chimneys
whimpers18276612whimpers
whimsies1635192whimsies
whimsy17375222whims_y_
whiskeys21353382whiskeys
whiteys16396152whi_teys
ahimsas1234783ahims_as
chimbleys2162233chimbleys
chimers144515143chim_ers
chimes134922573chim_e_s
chimley1785163chimley_
chimney1795483chimney_
chisels12219103chi_sels
hickeys19508223_hickeys
himself1544283_himself
hirsels10128343_hirsels
hissers104112313_hissers
hisses94719353_hisse_s
homeys145012873_hom_eys
hoseys124614003_h_oseys
limeys11429273_lim_eys
linseys1035083_linseys
malmseys1541903malmseys
phimoses1537203phimose_s
shiksehs1892093shiksehs
shikses14116573shikse_s
shimmers15269413shimmers
shinneys14275093shinneys
wheys145911553wh___eys
whickers20297983whickers
whiffers2064493whiffers
whiffets2072523whiffets
whiles124418013whi_le_s
whimbrels1941833whimbrels
whimper17297723whimpe_r
whims134515333whim___s
whimsied1743113whimsied
whiners134011573whi_ners
whines125120103whi_ne_s
whiney155012643whi_ney_
whingers15358723whingers
whinges143610633whinge_s
whippers18329043whippers
whippets18255253whippets
whiprays1942503whiprays
whipsaws1942693whipsaws
whirlers14286053whirlers
whishes16309443whi_shes
whishts16425313whi_shts
whiskers18306773whiskers
whiskey20445583whiskey_
whisks16497353whi_s_ks
whisky19455903whi_sky_
whispers16266993whispers
whists124613813whi_s_ts
whitens13428733whi_tens
whites123919883whi_te_s
whitey154911883whi_tey_
whities133113253whitie_s
whitters14359403whitters
whizzers2233423whizzers
whizzes2134713whizze_s
wifeys15425873w_i_feys
winceys15395523w_inceys
wises85633193w_i_se_s
wisses94619603w_isse_s
witneys13274723w_itneys

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.403443402.0
2DLD Change Limit146162706.87621256.8
3Display Results70700.0164375.0
 (SQL Overall)178691707.29524495.0
 
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.