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

49 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
whitlows174308(None) 
whitlow1642851whitlow_
willows13299752w_illows
billows123611293_billows
chitlins13289393chitlins
chitons122611913chit_ons
hallows134417393_hallows
hilloas104413553_hilloas
hilloes103815963_hilloes
hillos94618893_hillo_s
hitless103211193_hitless
hollows134412333_hollows
keitloas1242623keitloas
pillows122610123_pillows
shallows14388863shallows
shitless11249243shitless
shitload1294003shitload
shitloads1393503shitloads
waitrons1136633waitrons
wallows133613533w_allows
whatnots1442303whatnots
whiles124418013whi_l_es
whilom1436133whi_lo_m
whipsaws1942693whipsaws
whirlers14286053whirlers
whirlies14167373whirlies
whirls124710533whirl__s
whistlers1595163whistlers
whistles14108213whistl_es
whitens13428733whit_ens
whiteout1445583whiteout
whiteouts1543173whiteouts
whites123919883whit__es
whiteys16396153whit_eys
whities133113253whit_ies
whitings15287063whitings
whits115923823whit___s
whitters14359403whitters
whittlers1594333whittlers
whittles1496673whittles
widows1376563w_i_dows
willow12369693w_illow_
willowy16276353w_illowy
windows1447743w_indows
winnows1334533w_innows
witless103310983w_itless
witloof1344353w_itloof
witloofs1442503w_itloofs
wittols1035733w_ittols

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.1561145455.1
2DLD Change Limit146162497.36019859.0
3Display Results49490.0163062.5
 (SQL Overall)178691497.53223724.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.