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

140 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
syntax163430(None) 
nontax1348412nontax
suntan62613002suntan
surtax1337842surtax
syngas10368912syngas
syntagm1343312syntagm
syntaxes1843632syntaxes
synth113711822synt_h
synths12377882synths
anta46839583_anta_
antae56828293_antae
antas55432033_antas
banjax2234763banjax
bantam10314063bantam
cantal84122033cantal
centai84814783centai
cental84420963cental
centas85020703centas
dental74319173dental
fontal9313143fontal
handax1749583handax
hyetal1236543hyetal
hyrax1838033hy_rax
junta123713673junta_
juntas134210503juntas
kantar10311153kantar
lynx1437423lyn__x
lytta888063lytta_
lyttae994713lyttae
lyttas985073lyttas
manta75629913manta_
mantas85725363mantas
menta74424423menta_
mental84521603mental
myna95815303myn_a_
mynah13569563myn_ah
mynas105815233myn_as
pentad9313763pentad
pinta75727053pinta_
pintas85021393pintas
pretax152310193pretax
qintar15359143qintar
rental63922023rental
retax124517973_retax
sancta839833sancta_
sandal73317283sandal
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sanjak1735693sanjak
sansar63613393sansar
santir6315253santir
santo56227283sant_o
santol64515243santol
santos64421833santos
santur6311273santur
satay84718463s_atay
sax107447643s___ax
scuta75815753scuta_
seitan62613233seitan
senate63725173senate
sendal73314993sendal
senna54617983senna_
sennas64214233sennas
sensa54117473sensa_
sent46963013sent__
sente56432883sent_e
senti56226703sent_i
sentry92912053sentry
septa75518083septa_
septal84513383septal
seta45637313s_eta_
setae56026223s_etae
setal56430903s_etal
sextan13389643sextan
sinter63625923sinter
sitar54820543s_itar
smilax1535393smilax
snag55827873s_n_ag
snap65727033s_n_ap
snath86419803s_nath
snaw78923073s_n_aw
sneak96016173s_neak
sneap75514823s_neap
softa86415183softa_
softas94410403softas
sonar56523423son_ar
sonata6313223sonata
sonatas7510293sonatas
sorta57125413sorta_
spital83813873spital
sputa74612963sputa_
stab67329933s__tab
stag57332003s__tag
star48037763s__tar
stat47352693s__tat
statal61613223statal
staw78627693s__taw
stay78333723s__tay
storax1389783storax
styrax1675243styrax
subtaxa1644483subtaxa
sultan63012593sultan
sundae7312873sundae
sunna55016063sunna_
sunnah9369353sunnah
sunnas63914563sunnas
sunray9310123sunray
suntans72111733suntans
sutta54015333sutta_
suttas63813793suttas
sylva11268443sylva_
sylvae12236863sylvae
sylvan12257363sylvan
sylvas12288173sylvas
syn67024123syn___
sync95415103syn__c
syncarp1444533syncarp
synced12266963synced
synch135011793syn_ch
synchs14408453synchs
syncom1336093syncom
syncs104610173syn_cs
syndet10311963syndet
syndic1237303syndic
syne75725763syn__e
syngamy1643113syngamy
synod9610283syn_od
synodal1145743synodal
synods1077953synods
syntagma1442013syntagma
syntagms1442723syntagms
syntony1344523syntony
synura935983synura
synurae1044253synurae
syrinx1637143syrinx
system1135743system
tax109449153___tax
yenta83917043yenta_
yentas94614213yentas

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161404.64324276.5
3Display Results1401400.0304666.7
 (SQL Overall)1786911405.04635412.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.