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

210 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
sarin5523925(None) 
sabin74924941sabin
sain45551291sa_in
saran53730301saran
sari45444041sari_
sarins63932621sarins
saris54544951saris
sasin54626571sasin
satin55935211satin
savin84625081savin
serin55434441serin
agin56132712_agin
ain37579092_a_in
airn46433832_airn
akin86328032_akin
amin66042242_amin
aria46245422_aria
arid57642712_arid
aril45843022_aril
ayin76331742_ayin
bairn77515532bairn
baric96125692baric
baring95135852baring
barn66444642bar_n
baron78131242baron
basin75026922basin
brain76229382brain
brin67038192_brin
burin75626062burin
cabin94820932cabin
cain65643912ca_in
cairn75717512cairn
carina84325322carina
caring95137992caring
carlin84421822carlin
carn66245432car_n
daric85623112daric
daring84928682daring
darn56434622dar_n
drain65222892drain
earing75235482earing
earn46737552ear_n
estrin6315922estrin
fagin9216572fagin
fain75840562fa_in
farina94618232farina
faring105231282faring
gain56042162ga_in
gamin84422992gamin
garni6315702garni
grain65126252grain
grin55733722_grin
haring104233002haring
harmin113117392harmin
harpin113614382harpin
isatin6412212isatin
jarina134014062jarina
kain85334292ka_in
karn86129412kar_n
lain46146282la_in
lapin75222922lapin
lari45839152lari_
larine63927042larine
laris54737462laris
layin84720332layin
main65345502ma_in
margin94016842margin
maria75032882maria
marina84623412marina
marine84230402marine
marlin84220902marlin
martin84122522martin
matin75132852matin
mavin105722952mavin
mirin75023142mirin
naric76824172naric
narine63422552narine
naris55735292naris
oaring74225302oaring
pain65647242pa_in
parian83223962parian
paring94236492paring
paris75145942paris
patin76832852patin
pavin105623202pavin
purin75527592purin
rain46251732ra_in
raring74332872raring
ravin85624652ravin
rawin85521472rawin
rin36663182__rin
sabine84020382sabine
sabins85521972sabins
sabir75916992sabir
sabring102614842sabring
sacring103115982sacring
sadi55834642sadi_
sadis64930852sadis
sahib10314752sahib
said55742112sa_id
sail45447162sa_il
saimin8313662saimin
sains55639972sa_ins
saint55147072sa_int
saki85628472saki_
sakis95323662sakis
salic73424712salic
salina64221122salina
saline65132702saline
salon55228552salon
saning75127642saning
sapid84720932sapid
sarans64224432sarans
sarcina9310732sarcina
sard55344242sar_d
sardine83317392sardine
sards64736182sards
saree55044662saree
sarge65531132sarge
sargo65424412sargo
sark84938972sar_k
sarks96632462sarks
sarky125521782sarky
sarod65325872sarod
sarong73914872sarong
saros55238062saros
sarsen6314232sarsen
sasins64923102sasins
sati45539322sati_
sating74735452sating
satins64930482satins
satiny93817982satiny
satis55633672satis
saurian739912saurian
savarin10310002savarin
savine94220282savine
saving104724512saving
savins93923132savins
sawing104323812sawing
sawn75428162sa_wn
sayid95516722sayid
saying104325542saying
scaring103421972scaring
scrim95419722scrim
scrip96619192scrip
searing83330922searing
serein63318462serein
serif84132122serif
serine65432672serine
sering74731812sering
serins64029672serins
shairn9269062shairn
sharia93116722sharia
sharif122917112sharif
sharing113723242sharing
sharn84823702shar_n
shin75634302s_hin
shri76021692shri_
shrine94920052shrine
shrink134511732shrink
shris84221442shris
sin36265892s__in
siren54525822siren
siring75128312siring
skein94814402skein
skin85927522s_kin
slain54923572slain
snaring83920952snaring
soaring83521892soaring
sori46039832sori_
soring74731882soring
sorn46641062sor_n
sozin14514522sozin
sparid94016932sparid
sparing104823872sparing
spavin114210652spavin
spin66231302s_pin
sprain83614862sprain
sprig85617742sprig
spring94526012spring
sprint84526792sprint
sprit76736402sprit
sri35634002s_ri_
sris45434152s_ris
stain55727932stain
staring84527052staring
statin63921462statin
stearin7312002stearin
stein54620532stein
strain64919572strain
stria55723202stria
string75327562string
strip77524332strip
swain84919052swain
syren85216742syren
syrinx1637142syrinx
tain45548072ta_in
takin94921302takin
taring73932282taring
tarn46842722tar_n
train56529112train
tsarina736652tsarina
vain75233002va_in
varia85824202varia
varix154313502varix
wain75840192wa_in
waring105029442waring
warn75239322war_n
yarn75230042yar_n
zayin174512042zayin

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.1101624463.6
2DLD Change Limit538002101.73630990.8
3Display Results2102100.0603500.0
 (SQL Overall)1786912101.90693751.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.