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

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

158 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
errhine103659(None) 
errhines1136411errhines
archine125817052archine
ermine8416922e_rmine
erring73816482err_ing
murrhine1344312murrhine
reshine102816942reshine
terrine72517572terr_ine
airline7315033airline
archines133815253archines
arching136216693arching
archive154610483archive
arcsine94512393arcsine
arrive91311793arr_ive
arshin9312173arshin_
arshins10312573arshins
arsine64021043_arsine
berline93716853berline
berrying14137373berrying
berthing14209593berthing
beryline1337083beryline
brine75132273_br_ine
bromine112915243bromine
brucine1138273brucine
carbine112918643carbine
carline93923613carline
carmine112918483carmine
cervine122610803cervine
chine105231723__chine
corvine122113643corvine
crimine112413473crimine
crocine11314153crocine
earing75235483ear_ing
earning83418213earning
earphone1348253earphone
earring83519013earring
earthing12310323earthing
eccrine1137283eccrine
eching126315563e_ching
echini114710433e_chini
eerie55228533eer_i_e
elaphine1346113elaphine
elapine9310673elapine
emetine9712943emetine
enamine91214313enamine
engine71114863e_ngine
enshrine1147263enshrine
entwine1039143entwine
eosine64519413e_osine
equine151711573e_quine
erasing8317963erasing
eremite9312833eremite
erewhile1473673erewhile
erlking1236703erlking
ermined10410603e_rmined
ermines9416673e_rmines
erne46727433e_r__ne
eroding9314273eroding
erosive1039193erosive
erotize16311663erotize
errable9312183errable
errand758793err_and
errant6618733err_ant
erudite838483erudite
eserine7415903eserine
etamine91313073etamine
etching134511843etching
ethane94613243e_thane
ethene93312923e_thene
ethyne12407153e_thyne
eucaine939243eucaine
examine161510033examine
exine125518493e__xine
eyeshine1444543eyeshine
eyrie88117833eyr_i_e
ferine96422583fer_ine
ferrite103312753ferr_ite
ferrying15146243ferrying
gradine93317033gradine
gratine84719193gratine
harmine122816193harmine
heroine103517483heroine
herring113615883herr_ing
herrying15147023herrying
hircine1239143hircine
kerosine1238143kerosine
larine63927043lar_ine
machine14313493machine
marine84230403mar_ine
marline93320953marline
moraine9314573moraine
morphine1548703morphine
murine84220023mur_ine
murrine9411483murrine
nardine82712573nardine
narine63422553nar_ine
nervine102510633nervine
neurine7311683neur_ine
orpine83914483_orpine
orrice81410163orr_ice
pardine103616723pardine
perching163711633perching
porcine11312843porcine
praline93019743praline
primine113214823primine
proline92321593proline
promine112819443promine
propine113020213propine
purine85321893pur_ine
purline93516533purline
rapine85023083_rapine
ratine65131823_ratine
ravine95522223_ravine
recline94020493recline
redline84218833redline
refine95225693_refine
rehinge1148503_rehinge
rehire95415863_rehire
reline65434353_reline
repine85627813_repine
reraise7316313reraise
rerise64325633rer_ise
reshined123011123reshined
reshines112615443reshines
reshone102414163reshone
rethink1488883rethink
retine66237333_retine
rexine134719443_rexine
rhino84614323__rhino
rusine63916593_rusine
sardine83317393sardine
serine65432673ser_ine
serotine8313573serotine
serrying12167693serrying
shine85533093__shine
shrine94920053shr_ine
sordine82515233sordine
terrain7410853terrain_
terrains8410323terrains
terrane72814233terr_ane
terrene72411033terr_ene
terrines82117553terr_ines
thine85026863__thine
trephine1338933trephine
trine54734603_tr_ine
tropine93116653tropine
turbine9310303turbine
turdine8310283turdine
urchin1138743urchin_
urchins1238863urchins
uridine81311213uridine
urine55026603_ur_ine
ursine64114123_ursine
vahine123612113_vahine
versine102515173versine
wahine123813013_wahine
whine116022813__whine
zebrine1836463zebr_ine

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271585.90622693.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.37528030.0
 
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.