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

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

168 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
satin5593522(None) 
isatin6412211isatin
matin75132851matin
patin76832851patin
sabin74924951sabin
sain45551291sa_in
sarin55239251sarin
sasin54626571sasin
sati45539331sati_
sating74735451sating
satins64930481satins
satiny93817981satiny
satis55633681satis
savin84625081savin
stain55727941stain
statin63921471statin
actin74922552actin
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amin66042252_amin
astir55517092astir
ayin76331742_ayin
basin75026922basin
batik11614732batik
bating95132252bating
baton75822422baton
cabin94820942cabin
cain65643912ca_in
cation83925502cation
catkin123512382catkin
catlin83819082catlin
cutin75022782cutin
dating85326482dating
eaten55323052eaten
eating75134402eating
fagin9216572fagin
fain75840562fa_in
fating105328672fating
gain56042162ga_in
gamin84423002gamin
gating84826952gating
gratin74520582gratin
hating104929712hating
hatpin112610612hatpin
isatine7311762isatine
isatins7310772isatins
kain85334292ka_in
kation104315682kation
lain46146282la_in
lapin75222922lapin
laten54328342laten
lati46438272lati_
latina65621142latina
latino64120472latino
lattin64316222lattin
layin84720332layin
main65345522ma_in
martin84122522martin
mating94832912mating
matins84527782matins
mattin84416632mattin
mavin105722952mavin
nation64322802nation
oaten55222402oaten
pain65647242pa_in
paten74827342paten
patina86022192patina
patine85328122patine
patins87528782patins
patio74426352patio
pavin105623202pavin
rain46251732ra_in
ratan53722662ratan
ratine65131822ratine
rating74938702rating
ratio55227582ratio
ration64226012ration
ratlin64116522ratlin
ravin85624652ravin
rawin85521472rawin
rutin55421342rutin
sabine84020392sabine
sabins85521982sabins
sabir75917002sabir
sadi55834642sadi_
sadis64930852sadis
sahib10314762sahib
said55742112sa_id
sail45447162sa_il
saimin8313662saimin
sains55639972sa_ins
saint55147072sa_int
saith85826552saith
saki85628482saki_
sakis95323672sakis
salic73424712salic
salina64221122salina
saline65132702saline
salon55228552salon
saltie63422432saltie
saltine75018562saltine
salting84120792salting
saning75127642saning
santir6315252santir
sapid84720932sapid
saran53730302saran
sari45444042sari_
sarins63932622sarins
saris54544952saris
sasins64923102sasins
sat36288482sat__
satang75711562satang
satay84718462satay
sate45556102sat_e
sated66238532sated
sateen63815012sateen
satem76021462satem
sates54949322sates
satinet7325282satinet
satire63218002satire
satyr848482satyr
savine94220282savine
saving104724512saving
savins93923132savins
sawing104323812sawing
sawn75428162sa_wn
sayid95516722sayid
saying104325542saying
seating84130682seating
serin55434442serin
seton55223542seton
shin75634312s_hin
shtik123210962shtik
sin36265892s__in
siting74126622siting
skating123613852skating
skein94814412skein
skin85927532s_kin
slain54923572slain
slating83724652slating
sozin14514542sozin
spavin114210652spavin
spin66231302s_pin
staid66722082staid
staig65519642staig
stains64923652stains
stair54719942stair
static83118682static
stating83725162stating
statins73719772statins
station72717242station
stein54620542stein
sting65330242s_ting
stink95122502s_tink
stint57037662s_tint
stir45723252s_tir
stotin63215062stotin
stun45623452s_tun
swain84919052swain
tain45548072ta_in
takin94921302takin
tin36362172__tin
vain75233002va_in
vatic10316422vatic
wain75840202wa_in
zayin174512042zayin
zeatin15412822zeatin

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001681.50035866.7
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.84297009.2
 
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.