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

104 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
savine9422028(None) 
ravine95522221ravine
sabine84020391sabine
saline65132701saline
savin84625081savin_
savines104417631savines
saving104724511saving
savins93923131savins
aline57243152_aline
alvine94614582alvine
amine75835382_amine
azine146721412_azine
bovine11712432bovine
canine83826702canine
cavie104621592cavi_e
caving124822612caving
divine103514462divine
famine114318192famine
flavine1338452flavine
gamine94620152gamine
having134220372having
isatine7311762isatine
larine63927042larine
laving104623572laving
lawine93316462lawine
maline84529082maline
marine84230402marine
mavie104722562mavi_e
mavin105722952mavin_
mavins115119182mavins
narine63422552narine
ovine86316642_ovine
patine85328122patine
pavane114113442pavane
pavin105623202pavin_
paving124519742paving
pavins114919662pavins
pavise114714802pavise
rapine85023082rapine
ratine65131822ratine
ravin85624652ravin_
ravined115411822ravined
ravines104220232ravines
raving105128852raving
ravins94622562ravins
sabin74924952sabin_
sabines94318482sabines
sabins85521982sabins
saice75424052sa_ice
sain45551292sa_in_
sained75424242sa_ined
sains55639972sa_ins
saint55147072sa_int
salina64221122salina
salines74029412salines
saltine75018562saltine
salving113913152salving
samite83020602samite
sane45954342sa__ne
saning75127642saning
sardine83317392sardine
sarin55239252sarin_
sarins63932622sarins
sasin54626572sasin_
sasins64923102sasins
satin55935222satin_
satinet7325282satinet
sating74735452sating
satins64930482satins
satiny93817982satiny
satire63218002satire
savage10410172savage
savant9416042savant
savate9313782savate
save75741362sav__e
savings114412952savings
savior9710172savior
sawing104323812sawing
saying104325542saying
seine55732872s_eine
serine65432672serine
shavie124312422shavi_e
shaving143414332shaving
shine85533092s_hine
shrine94920052shrine
sine46560622s__ine
slaving113514832slaving
sozine15712352sozine
spavie113611382spavi_e
spavin114210652spavin_
spavined1434332spavined
spavins12419322spavins
spine76534422s_pine
spline86020532spline
stanine73417072stanine
staving113915702staving
supine84216692supine
swine85625302s_wine
sylvine13216542sylvine
vahine123612112vahine
valine94623092valine
vine75643682__vine
wahine123813012wahine
waving134018202waving

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.343520965.0
2DLD Change Limit825511042.31335690.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911042.68666526.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.