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

176 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
santours83718(None) 
santoors837631santoors
santour737371santour_
santurs7310761sant_urs
candours11408642candours
cantors94620752canto_rs
contours1039652contours
faitours1134262faitours
pandours11317992pandours
pantoums1236712pantoums
rancours1076712rancours
sandburs11105622sandburs
sanious7514102saniou_s
santirs7312962sant_irs
santols73513322santo_ls
santoor737432santoor_
santos64421832santo__s
santur6311272sant_ur_
sapours93610622sa_pours
sartors7314962sarto_rs
sautoirs834922sautoirs
saviours1154272saviours
savours10389342sa_vours
stours65015632s__tours
actors81016763_acto_rs
amours83512663_a_mours
anthers103715203_anthers
antiars7314623_antiars
antlers74014743_antlers
antrums969173_antrums
arbours93910043_arbours
ardours8368883_ardours
armours9389853_armours
auteurs7137503_auteurs
banters94623113bant_ers
candors104216763cando_rs
candour104210243candour_
canoers94318373can_oers
canters94827733cant_ers
canthus1248713canthu_s
cantons95221203canto_ns
cantor85621523canto_r_
cantos84826973canto__s
cantus85117763cant_u_s
captors113914983capto_rs
castors94919443casto_rs
centaurs1035733centaurs
chantors133710263chanto_rs
clangours12263123clangours
concours1239473concours
contour939973contour_
danseurs933433danseurs
detours858043_detours
ecotours1044463ecotours
enamours1044663enamours
factors12912123facto_rs
faitour1034883faitour_
fantods11177623fanto_ds
fantoms12189153fanto_ms
favours13437093fa_vours
gators74115833ga_to_rs
grantors93810353granto_rs
handouts1238233handouts
hangouts1236183hangouts
harbours1346923harbours
hauteurs1133733hauteurs
haviours1443843haviours
honours10339373hon_ours
inpours936423_inpours
janitors1536853janito_rs
kantars11310033kant_ars
labours9349893la_bours
languors976153languors
langurs889103lan_gurs
manitous1039173manitou_s
manors84420883man_o_rs
mantuas93410993mant_uas
mentors9314993mento_rs
pandoors11258983pandoors
pandour10408213pandour_
panthers13510783panthers
pantos85222743panto__s
pantoum1138703pantou_m
parlours1036153parlours
pastors94119003pasto_rs
paviours1343613paviours
rancors9811373ranco_rs
rancour987133rancour_
ranters73323643rant_ers
raptors94213353rapto_rs
saboteurs1141863saboteurs
sailors73213723sailo_rs
sajous13310583sa_jou_s
salters73622253salt_ers
saltiers83411953saltiers
salvors103910913salvo_rs
sambhurs1543183sambhurs
samburs11369343sa_mburs
sanctums1244013sanctums
sandbars11108783sandbars
sandbur10105353sandbur_
sandburr11123223sandburr
sandburrs12112783sandburrs
sanders84025943san_ders
sandspurs1242583sandspurs
sangars83116253san_gars
sangers84421943san_gers
sannops936693sanno_ps
sannups934463san_nups
sansars73313913san_sars
santera7311303sant_era
santeras8311063santeras
santero7311133sant_ero
santeros8311193santeros
santims9312603sant_ims
santir6315253sant_ir_
santo56227283santo___
santol64515243santo__l
santonin849703santonin
santonins948453santonins
sapors84118813sa_po_rs
sapour83812373sa_pour_
sarcous9312933sarcou_s
sartor6313873sarto_r_
satori6415843sa_to_ri
satoris7317253sa_toris
satyrs937963sa_t_yrs
saunters82911753saunt_ers
sautoir735183sautoir_
sautoire844493sautoire
sautoires944793sautoires
saviors1058993savio_rs
saviour1035213saviour_
savors95616103sa_vo_rs
savour94110703sa_vour_
savoury13365873sa_voury
scours84913593s__cours
sectors93116443secto_rs
senators8312953senato_rs
senhors103512123senho_rs
seniors73413613senio_rs
senors63620783sen_o_rs
sensors73514633senso_rs
setous64917373s_etou_s
setouts74110333s_etouts
shutouts1143823shutouts
sinters74024083sint_ers
sinuous739063sinuou_s
snouts64915873s_n_outs
sours55230503s___ours
standouts1044983standouts
stannous846443stannou_s
stators73915583stato_rs
stentors839733stento_rs
stoups85313273s__toups
stour54916743s__tour_
stoure64814943s__toure
stoures74614163s__toures
stoury9529943s__toury
stouts65019003s__touts
succours1244593succours
suitors73012493suito_rs
surtouts846203surtouts
tabours94110093ta_bours
tambours1255873tambours
tandoors9258053tandoors
tantrums1045113tantrums
tenours72610073ten_ours
tours55325893___tours
valours10248743va_lours
vapours12277463va_pours
wanters104420093want_ers
wantoners12116673wantoners
wantons103713013wanto_ns
watthours1542813watthours
xanthous1846643xanthou_s

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.1561145455.1
2DLD Change Limit1461621767.32619951.1
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.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.