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

68 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
safetied124466(None) 
safeties1139161safeties
safaried1236252safaried
abetted1058323_abetted
aeried74221863_a_eried
afeared1176833_afeared
asafetida1351373asafetida
casefied1445943casefied
cavitied14126813cavitied
faceted13509563facet_ed
facetted1445743facetted
feted94420933__fet_ed
fetid93715983__feti_d
fetted104817893__fetted
gaieties9310183gaieties
gayeties1236883gayeties
gazetted19234853gazetted
hafted134713833haf_t_ed
partied103516553pa_rtied
rafted104714703raf_t_ed
raftered1237663raftered
rarefied1245913rarefied
retied75924983__retied
sabered103213023sabe_red
sacheted14127833sachet_ed
safety12206913safet__y
safetying1643073safetying
safetymen1751743safetymen
sainted84114243saint_ed
salaried9311023salaried
salified12310363salified
sallied83316953sa_llied
salted74121203sa_lt_ed
saltie63422433sa_ltie_
saltier74318633sa_ltier
salties73725773sa_lties
saluted84511713salut_ed
sanities81219773sanities
sanitised10147353sanitised
sanitized19138173sanitized
sated66238533sa__t_ed
satieties939383satieties
sauted74119603sa_ut_ed
sauteed8349613sa_uteed
savvied1433803sa_vvied
seethed113410193s_eethed
shafted14288813shaf_t_ed
sheeted113813043sheet_ed
sheetfed1544143sheetfed
sifted104313673sif_t_ed
sleeted83113223sleet_ed
sleetier837883sleetier
softened1235663softened
softie93312483sof_tie_
softies103414613sof_ties
sortied83314103s_ortied
stetted82610403s_tetted
stied65723033s___tied
sureties8316583sureties
surfeited1344593surfeited
sweetie10157873sweetie_
sweeties11159723sweeties
taffetized2651693taffetized
unsafeties1362103unsafeties
valeted1139013valet_ed
vanitied12138213vanitied
wafered14288433wafe_red
wafted134012143waf_t_ed

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.423422437.4
2DLD Change Limit146162687.10620568.8
3Display Results68680.0164250.0
 (SQL Overall)178691687.54523683.4
 
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.