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

178 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
satins6493048(None) 
isatins7310771isatins
matins84527781matins
patins87528781patins
sabins85521981sabins
sains55639971sa_ins
sarins63932621sarins
sasins64923101sasins
satin55935221satin_
sating74735451sating
satiny93817981satiny
satis55633681sati_s
savins93923131savins
stains64923651stains
statins73719771statins
actins86321102actins
ains46158892_a_ins
amins75534322_amins
ayins85321612_ayins
basins85722762basins
batiks1239372batiks
bating95132252bating
batons85519422batons
cabins104418922cabins
cains75334302ca_ins
cations94524142cations
catkins133012562catkins
catlins93818842catlins
cutins83919982cutins
dating85326482dating
eating75134402eating
eatings84616442eatings
fagins10513862fagins
fating105328672fating
gains65729512ga_ins
gamins94420052gamins
gating84826952gating
gatings95212822gatings
gratins84119182gratins
hating104929712hating
hatpins123410642hatpins
isatin6412212isatin_
isatine7311762isatine
isatines8310662isatines
kains96125652ka_ins
kations114013662kations
lapins84520682lapins
latens64620212latens
latina65621142latina
latinas74416462latinas
latino64120472latino
latinos73613802latinos
lattins74115482lattins
layins93817652layins
mains75635112ma_ins
martins93322062martins
matin75132852matin_
mating94832912mating
matings104516212matings
mattins93316142mattins
mavins115119182mavins
nations74720562nations
pains75138282pa_ins
patens84820862patens
patin76832852patin_
patina86022192patina
patinas96318532patinas
patine85328122patine
patines95225772patines
patios85221792patios
pavins114919662pavins
rains55140232ra_ins
ratans63819372ratans
ratine65131822ratine
ratines75328582ratines
rating74938702rating
ratings84217412ratings
rations74123432rations
ratios64922672ratios
ratlins73615582ratlins
ravins94622562ravins
rawins95617622rawins
rutins63818392rutins
sabin74924952sabin_
sabine84020392sabine
sabines94318482sabines
sabirs85414632sabirs
sadis64930852sadi_s
sahibs1137082sahibs
saids65328862sa_ids
sails55738102sa_ils
saimins9312112saimins
sain45551292sa_in_
saint55147072sa_int
saints65122422sa_ints
sakis95323672saki_s
salina64221122salina
salinas73116092salinas
saline65132702saline
salines74029412salines
salons63823692salons
salties73725772salties
saltine75018562saltine
saltines82917792saltines
salting84120792salting
saltings92811252saltings
sanies63031952sanies
saning75127642saning
sans45153362sa__ns
santims9312602santims
santirs7312962santirs
sapiens9310172sapiens
sarans64224432sarans
sarin55239252sarin_
saris54544952sari_s
sasin54626572sasin_
satang75711562satang
satangs8479712satangs
satays94411682satays
sateens73710752sateens
sates54949322sat_es
sati45539332sati__
satinet7325282satinet
satinets8311732satinets
satire63218002satire
satires72617572satires
satyrs937962satyrs
savin84625082savin_
savine94220282savine
savines104417632savines
saving104724512saving
savings114412952savings
sawing104323812sawing
sayids104310972sayids
saying104325542saying
sayings113610832sayings
seating84130682seating
seatings93614302seatings
serins64029672serins
setons64620172setons
shins85131042s_hins
shtiks13297832shtiks
sins46755282s__ins
siting74126622siting
skating123613852skating
skatings13326992skatings
skeins103911902skeins
skins94723472s_kins
slating83724652slating
slatings94011722slatings
sozins15510792sozins
spavins12419322spavins
spins75327982s_pins
staigs75414812staigs
stain55727942stain_
stairs65416332stairs
statics93314532statics
statin63921472statin_
stating83725162stating
stations82415222stations
steins64818342steins
sties55132982s_ties
sting65330242s_ting
stings76220182s_tings
stink95122502s_tink
stinks105616832s_tinks
stint57037662s_tint
stints65119762s_tints
stirs55921622s_tirs
stotins73213872stotins
stuns54719492s_tuns
swains94513952swains
tains54936322ta_ins
takins105117402takins
tins45251312__tins
wains86930872wa_ins
zayins18409712zayins
zeatins16311732zeatins

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit825511782.31035736.4
3Display Results1781780.0463869.6
 (SQL Overall)1786911782.70266132.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.