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

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

63 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
waisting12361521(None) 
waistings1352710761waistings
waiting113618951wai_ting
wasting114422841wa_sting
whisting15329541whisting
wisting113519741w_isting
agisting1038242agisting
airting83616302_airting
awaiting1238272awai_ting
baiting103918882bai_ting
basting104227202ba_sting
casting104628342ca_sting
easting84924302ea_sting
existing1639072existing
fainting123312162fainting
fasting114522832fa_sting
fisting113818122_fisting
foisting122910502foisting
gaiting93716582gai_ting
gasting95022762ga_sting
hasting114725192ha_sting
heisting123411042heisting
histing113720372_histing
hoisting123610902hoisting
joisting16328502joisting
lasting84725242la_sting
listing84020592_listing
masting104325822ma_sting
misting103623382_misting
painting113614422painting
pasting103826552pa_sting
raising83220532rais_ing
sainting93215732sainting
tainting93613582tainting
tasting84624212ta_sting
twisting12427812twisting
wafting143911662wa_fting
waifing142910892wai_fing
wailing113620902wai_ling
wairing113414312wai_ring
waistline1244172waistline
waitings123413742wai_tings
waiving14329632wai_ving
wanting114220172wa_nting
warsling12198592warsling
warstling1335062warstling
washing145119282wa_shing
westing115020272w_esting
whishing18287182whishing
whishting1983562whishting
whisking19286612whisking
whistling1644732whistling
whiting143311302whi_ting
wilting113515912w_ilting
wishing144114892w_ishing
wising103318222w_is_ing
wisping133711942w_isping
wissing113212942w_issing
witing103522822w_i_ting
witting113417062w_itting
worsting1267682worsting
wresting123811832wresting
writing113713892wri_ting

Search took 4 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 Filter1786911210590.390458182.1
2DLD Change Limit121059633.39035710.6
3Display Results63630.0163937.5
 (SQL Overall)178691633.79647073.5
 
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.