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

138 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
errhines113641(None) 
errhine1036591errhine_
archines133815252archines
ermines9416672e_rmines
reshines112615442reshines
terrines82117552terr_ines
airlines8312793airlines
archine125817053archine_
archings14499863archings
archives16399553archives
arcsines104010353arcsines
arrises71617583arr_ises
arrives101311513arr_ives
arshins10312573arshin_s
arsines73518833_arsines
berlines102315453berlines
berries94423553berr_i_es
brines85028853_br_ines
bromines122514253bromines
brucines1237763brucines
carbines123617553carbines
carlines103521673carlines
carmines123617883carmines
chines115029173__chines
derries83124623derr_i_es
derrises93012783derr_ises
earings84517713ear_ings
earliness939703earliness
earnings9419333earnings
earphones1448393earphones
earrings9299633earrings
earthiness1377243earthiness
echinus1236203e_chinus
eeriness8311873eer_iness
emetines10611053emetines
enamines101112133enamines
engines81114463e_ngines
enshrines1246583enshrines
entwines1148753entwines
eosines73718293e_osines
equines161811593e_quines
eremites10312603eremites
erewhiles1563173erewhiles
erlkings1333563erlkings
ermine8416923e_rmine_
ermined10410603e_rmined
ernes55224813e_r__nes
erotizes17311213erotizes
errands847603err_ands
errants7410643err_ants
erring73816483err_in_g
eserines8413743eserines
etamines101611813etamines
etchings14396293etchings
ethanes103713513e_thanes
ethenes103313873e_thenes
ethynes13377573e_thynes
eucaines1038513eucaines
examines17128793examines
exines135715803e__xines
eyeshines1544253eyeshines
eyries93816813eyr_i_es
ferries103521083ferr_i_es
ferrites112312833ferr_ites
gradines103615253gradines
harmines132715153harmines
heroines112916573heroines
herries104025083herr_i_es
herrings12379533herr_ings
jerries143817513jerr_i_es
kerosines1357113kerosines
kerries113317913kerr_i_es
machines15312893machines
marines93928033mar_ines
marlines103818743marlines
merriness1138293merr_iness
moraines10314373moraines
morphines1648233morphines
murines93718223mur_ines
murrhine1344313murrhine_
nervines112310463nervines
neurines8311193neur_ines
orchises1338773orchises
ordines83014903_ordines
orpines94414793_orpines
orrices9129363orr_ices
orrises71312233orr_ises
perries93226603perr_i_es
pralines102217733pralines
primines123013703primines
prolines102619693prolines
promines123018803promines
propines122618933propines
purines94420773pur_ines
purlines103514063purlines
rapines95120863_rapines
ratines75328583_ratines
ravines104220233_ravines
reclines103718543reclines
redlines93916083redlines
refines105426343_refines
rehinges1248403_rehinges
rehires105016113_rehires
relines75331323_relines
repines94927383_repines
reraises8415643reraises
rerises73525883rer_ises
reshine102816943reshine_
reshined123011123reshined
rethinks1576033rethinks
retines75134673_retines
rexines144719153_rexines
rhinos94411123__rhinos
sardines92815583sardines
serines74229543ser_ines
serotines9312073serotines
serries73925353serr_i_es
shines95028913__shines
shrines104618693shr_ines
sordines92414073sordines
teredines1049453teredines
terrains8410323terrain_s
terranes82514433terr_anes
terrenes82212603terr_enes
terries73425633terr_i_es
terrine72517573terr_ine_
trephines1448483trephines
trines64132563_tr_ines
tropines102214923tropines
turbines1039903turbines
urchins1238863urchin_s
uridines989513uridines
urines64724123_ur_ines
vahines133410523_vahines
versines112213823versines
wahines133111173_wahines
whines125120103__whines
zebrines1935883zebr_ines

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621386.53022383.2
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.01625469.1
 
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.