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

52 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
swiftnesses174450(None) 
shiftinesses18105242shiftinesses
softnesses1337602s_oftnesses
stiffnesses1743592stiffnesses
swartnesses1436712swartnesses
sweetnesses1445722sweetnesses
swiftness1543652swiftne_s_s
witnesses12219922_wi_tnesses
daftnesses1436383_daftnesses
deftnesses1436813_deftnesses
faintnesses1447143faintnesses
fitnesses12219373_fi_tnesses
moistnesses1347153moistnesses
niftinesses1437243_niftinesses
quietnesses2045603quietnesses
rifenesses1339943_rifenesses
safenesses1349373s_afenesses
saltnesses10310163s_altnesses
scantnesses1376533scantnesses
selfnesses1335893self_nesses
shininesses1448293shininesses
shortnesses1446793shortnesses
sicknesses1636763s_icknesses
sizinesses1938653s_izinesses
slicknesses1745193slicknesses
slightnesses1654623slightnesses
sliminesses1338093sliminesses
slimnesses1236423sli_mnesses
smartnesses1337143smartnesses
snidenesses1248653snidenesses
sniffinesses1843693sniffinesses
spicinesses1547103spicinesses
spiffinesses2043013spiffinesses
spikinesses1746523spikinesses
spininesses1358453spininesses
squatnesses2045213squatnesses
stillnesses1146733stillnesses
stoutnesses1146973stoutnesses
strictnesses1445413strictnesses
sweatinesses1546913sweatinesses
unfitnesses1446133unfitnesses
wetnesses12208213_w_etnesses
whatnesses1635733_whatnesses
widenesses1438773_widenesses
wildnesses14157363_wildnesses
wilinesses131911093_wilinesses
wirinesses131811523_wirinesses
wisenesses13310823_wisenesses
witnessed13214723_wi_tnessed
witnesser12224533_wi_tnesser
witnessers13173103_wi_tnessers
wittinesses14127483_wittinesses

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633525.26623097.8
3Display Results52520.0331575.8
 (SQL Overall)178691525.68931409.9
 
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.