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

153 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
saline6513270(None) 
aline57243151_aline
maline84529081maline
sabine84020391sabine
salina64221121salina
salines74029411salines
saltine75018561saltine
savine94220281savine
spline86020531spline
valine94623091valine
alane56135612_alane
alien56425582_alien
alike95523962_alike
alined75221402_alined
aliner65621982_aliner
alines65735222_alines
alive85722512_alive
alkine104916802_alkine
alone55732962_alone
alpine84417372_alpine
alvine94614582_alvine
amine75835382_amine
azine146721412_azine
baling94829692baling
byline11311642byline
calcine11315272calcine
canine83826702canine
carline93923612carline
cauline92215602cauline
cline76428532_cline
famine114318192famine
feline94820142feline
gamine94620152gamine
halide103417992halide
haling104229782haling
halite93624232halite
hyaline132310722hyaline
isatine7311762isatine
isoline7314012isoline
jawline17137062jawline
kaoline11310142kaoline
larine63927042larine
lawine93316462lawine
line46965572__line
malice104818482malice
malines93625602malines
marine84230402marine
marline93320952marline
moline84422032moline
narine63422552narine
online6315842online
opaline9412482opaline
paling93530132paling
patine85328122patine
praline93019742praline
ralline73518412ralline
rapine85023082rapine
ratine65131822ratine
ratline74517802ratline
ravine95522222ravine
reline65434352reline
sabin74924952sabin_
sabines94318482sabines
sabins85521982sabins
saclike131210122saclike
saice75424052sa_ice
sailing83927372sailing
sain45551292sa_in_
sained75424242sa_ined
sains55639972sa_ins
saint55147072sa_int
sale44959702sal__e
salic73424712sali_c
salicine10311702salicine
salience10117902salience
salient7419762salient
salify12311372salify
salinas73116092salinas
salinize1739682salinize
saliva93110742saliva
salon55228552salon_
salons63823692salons
salpae84614272salpae
salpinx1636092salpinx
saltie63422432saltie
saltines82917792saltines
salting84120792salting
saltire73113032saltire
salute64418022salute
salve85022132sal_ve
salving113913152salving
samite83020602samite
sane45954342sa__ne
saning75127642saning
sapling103217862sapling
sardine83317392sardine
sarin55239252sarin_
sarins63932622sarins
sasin54626572sasin_
sasins64923102sasins
satin55935222satin_
satinet7325282satinet
sating74735452sating
satins64930482satins
satiny93817982satiny
satire63218002satire
savin84625082savin_
savines104417632savines
saving104724512saving
savins93923132savins
sawing104323812sawing
sawlike14138442sawlike
saying104325542saying
scalene9310772scalene
scaling103519372scaling
sealing83528562sealing
seine55732872s_eine
sepaline10311342sepaline
serine65432672serine
setline7313922setline
shine85533092s_hine
shrine94920052shrine
silane62718052silane
sine46560622s__ine
skyline1436792skyline
slain54923572slain_
slainte738542slainte
slice74925822s_lice
slide64725412s_lide
slime74925752s_lime
sling66028802s_ling
slink95422912s_link
slipe75626132s_lipe
smaltine1037832smaltine
soling74226822soling
sozine15712352sozine
spine76534422s_pine
splice104915102splice
splined105013112splined
splines94718892splines
splint85223282splint
staling83925422staling
stanine73417072stanine
subline9316892subline
supine84216692supine
swine85625302s_wine
sylvine13216542sylvine
tagline82412452tagline
vahine123612112vahine
valines104520212valines
valise92917642valise
wahine123813012wahine
waling104525302waling

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.326548131.9
2DLD Change Limit825511532.59331836.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911532.96560266.8
 
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.