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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
sautoir73518(None) 
sautoire844501sautoire
sautoirs834921sautoirs
santir6315252sant_ir
santoor737432santoor
santour737372santour
sartor6313882sarto_r
satori6415842sa_tori
sautoires944802sautoires
abattoir1042053abattoir
actor71116083_acto_r
astir55517093_ast_ir
auteur6107943_auteur
author939763_author
auto47432083_auto__
autoed7712823_autoed
autogiro943403_autogiro
autoing8314043_autoing
autos56523323_auto_s
boudoir1043853boudoir
cactoid12311033cactoid
cantor85621523canto_r
captor104914603capto_r
castor84418533casto_r
caution93013523caution
couloir936153couloir
dautie72914703daut_ie
factoid1338693factoid
factor11911463facto_r
faitour1034883faitour
gator64416043ga_to_r
hautbois1343103hautbois
hauteur1033893hauteur
maftir1136493maft_ir
mastoid10711233mastoid
mattoid1079283mattoid
pastor84817483pasto_r
patois84319363pa_tois
raptor83912823rapto_r
sabir75917003sa__bir
sailor63113753sailo_r
salter64325083salt_er
saltie63422433salt_ie
saltier74318633saltier
saltire73113043salt_ire
saluter73512453salut_er
salvor94711093salvo_r
santirs7312963sant_irs
santo56227283santo__
santol64515243santo_l
santols73513323santols
santonin849703santonin
santoors837633santoors
santos64421833santo_s
santours837183santours
santur6311273sant_ur
sapor75119253sa_po_r
sapour83812373sa_pour
sarcoid10310453sarcoid
sartorii845583sartorii
sartors7314973sartors
sati45539333sa_t_i_
satin55935223sa_t_in
satire63218003sa_t_ire
satis55633683sa_t_is
satoris7317253sa_toris
satyr848483sa_t_yr
saucer84314103sau_cer
saucier9810283saucier
sauger74316253sau_ger
saunter72913453saunter
saute55028083saut__e
sauted74119603saut_ed
sauteed8349613sauteed
sauteing937913sauteing
sautes63924913saut_es
savior9710173savio_r
saviour1035213saviour
savor85417943sa_vo_r
savour94110703sa_vour
scutter93512173scutter
sector83415933secto_r
shutoff1693203shutoff
shutout1048533shutout
shutter103712143shutter
sluttier836453sluttier
smuttier1035213smuttier
souter64225923sout_er
souther104116303souther
sputnik1372273sputnik
sputter94014053sputter
stair54719943s__tair
stator64015483stato_r
stir45723253s__t_ir
stoic7317253s__toic
stour54916743s__tour
stupor836013stupo_r
stutter72911463stutter
sudor6312623s_udo_r
suitor63311053suito_r
sutler63718393s_utler
tauter64318023taut_er
tautog765713tauto_g
tautogs875413tautogs
tautomer1044593tautomer
tutor5712493_tuto_r
yautia937253yaut_ia

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271076.67320085.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.12525079.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.