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

73 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
swiftness154365(None) 
shiftiness1644792shiftiness
shiftless15265302shiftless
softness1136432s_oftness
stiffness1543552stiffness
swartness1236112swartness
sweetness1245682sweetness
swifters14277482swift_ers
swiftest1434352swift_est
swiftlets1542722swiftlets
swiftnesses1744502swiftnesses
witness103010012_wi_tness
daftness1235533_daftness
deftness1236303_deftness
faintness1235833faintness
fitness10299393_fi_tness
giftless1245173_giftless
moistness1146343moistness
niftiness1236363_niftiness
quietness1844753quietness
rifeness1138583_rifeness
riftless1136943_riftless
safeness11239633s_afeness
saltness82610243s_altness
scantness1135733scantness
selfness1135153self_ness
shifters14319863shift_ers
shiftiest1537363shiftiest
shininess1237333shininess
shirtless12266413shirtless
shitless11249243shi_tless
shortness1236733shortness
sickness1437833s_ickness
sifters103714793s_ift_ers
siziness1737423s_iziness
skiffless19243053skiffless
skirtless13254423skirtless
slickness1535903slickness
slightness1454803slightness
sliminess1137423sliminess
slimness1036523sli_mness
slitless8268143sli_tless
smartness1136143smartness
snideness1067683snideness
sniffiness1643763sniffiness
snifters11318613snift_ers
spiciness1347053spiciness
spiffiness1842983spiffiness
spikiness1536313spikiness
spininess1137963spininess
squatness1844943squatness
stillness936103stillness
stoutness945863stoutness
strictness1245643strictness
sweatiness1336463sweatiness
swifter13318053swift_e_r
swiftlet1444793swiftle_t
swifts12408173swift___s
swinneys14264203swi_nneys
swithers144310533swi_thers
unfitness1244843unfitness
wetness10277723_w_etness
whatness1435093_whatness
wideness12259473_wideness
wifeless14277483_wifeless
wiftiest14279173_wiftiest
wildness1236203_wildness
wiliness1139113_wiliness
wiriness1138953_wiriness
wiseness112010753_wiseness
witless103310983_wi_tless
witneys13274723_wi_tneys
wittiness12197223_wittiness

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 Filter1786911486410.406440125.6
2DLD Change Limit148641736.65622331.9
3Display Results73730.0302433.3
 (SQL Overall)178691737.09225196.1
 
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.