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

51 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
waygoings174220(None) 
waygoing1633271waygoing_
playgoings1792372playgoings
waypoints1742442waypoints
ageings9437693_a_geings
agings86312673_a_g_ings
anglings10228273_anglings
baggings13307523ba_ggings
easygoing1461753easygoing_
faggotings1641633faggotings
fagotings1443153fa_gotings
gaywings1633193gay_wings
goings84911523___goings
hangings13258583hang_ings
hayings14379393hay__ings
kayakings1642683kayakings
kayoing1535403kay_oing_
laggings11298403la_ggings
laughings1443483laughings
layerings13235683layerings
mayings134410513may__ings
outgoings1143953outgoings
pagings114411063pa_g_ings
pargings123410163parg_ings
playgoing1663563playgoing_
sayings113610833say__ings
tangoing10177893tangoing_
waddings14356473wa_ddings
wafflings1943023wafflings
wagging133313353wa_gging_
waggling14197063waggling_
waggoning1543593waggoning_
waggons1235503waggo_n_s
waging114318383wa_g_ing_
wagoning1336923wa_goning_
wagons103911213wa_go_n_s
waistings1352710763waistings
waitings123413743wa_itings
wakenings1743043wakenings
walkings16327313wa_lkings
wallopings1652713wallopings
wangling132310993wangling_
warnings12358453wa_rnings
washings15419273wa_shings
waterings13229253waterings
waxings18366453wa__xings
waxwings2232953wa_xwings
wayfarings2041783wayfarings
waypoint1645333waypoin_t
wiggings14316173w_iggings
wingdings1543683wingdings

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 Filter1786911486410.420425454.8
2DLD Change Limit148641516.04624585.0
3Display Results51510.0163187.5
 (SQL Overall)178691516.48227567.3
 
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.