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

120 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
trephine133893(None) 
trephined1544901trephined
trephines1448481trephines
repine85627812_rep_ine
reshine102816942_reshine
trapline10411862trapline
tropine93116652trop_ine
archine125817053ar_chine
atropine10410113atrop_ine
camphine1738373camphine
creatine103417413creatine
creping122913653crep_ing
dauphine1444493dauphine
elaphine1346113elaphine
erepsin937383erepsin_
erepsins1037443erepsins
erewhile1473673erewhile
errhine1036593er_rhine
eyeshine1444543eyeshine
freshing152611023freshing
graphing1538533graphing
graphite1447153graphite
grapline1138723grapline
morphine1548703morphine
orpine83914483or_p_ine
pepsine11310603_pepsine
preppie1058093preppi_e
prepping12309763prepping
preprice1488873preprice
preprint12314183preprint
propine113020213prop_ine
psephite1543843psephite
raphide13138073_raphide
rapine85023083_rap_ine
recline94020493_recline
redline84218833_redline
refine95225693_re_fine
rehinge1148503_re_hinge
rehire95415863_re_hire
reline65434353_re_line
repaint9318363_repaint
repin75324703_rep_in_
repined104918773_rep_ined
repiner94816903_rep_iner
repines94927383_rep_ines
repins84924313_rep_ins
repping123314983_repping
reprice113212833_reprice
reprint9318983_reprint
reprise92715043_reprise
reptile93914083_reptile
reshined123011123_reshined
reshines112615443_reshines
reshone102414163_reshone
rethink1488883_rethink
retine66237333_re_tine
rexine134719443_re_xine
tapeline10310363tapeline
techie11511723t_echi_e
teething1237163teething
telephone1445643telephone
tephrite1346593t_ephrite
terpene92310863terp_ene
terrine72517573t_errine
thebaine1355423thebaine
theine94814923the__ine
thine85026863t___hine
threonine1245103threonine
threshing1645663threshing
tiepin839343tiep_in_
tiepins939463tiep_ins
topline92313183t_opline
tramline10311383tramline
traplike1437653traplike
traplines11310373traplines
trapping132911393trapping
trashing122613223trashing
treading103515333treading
treating92519613treating
treatise8311103treatise
trebling1139873trebling
treeing83414303tre_eing
treelike1237003treelike
trekking1235543trekking
trenching15227653trenching
trending103012833trending
trepan82511673trep_an_
trepang10257293trep_ang
trepanned1243913trepanned
trepanner1143523trepanner
trepans92311593trep_ans
trephining1644933trephining
trepid9310083trep_i_d
triazine1738503triazine
trichina1348093trichina
trichinae1444703trichinae
trichite1349333trichite
trine54734603tr___ine
triphase1346193triphase
triplane1039113triplane
tripling112712553tripling
triplite1039103triplite
tripping133210923tripping
triptane1047563triptane
tripwire1343603tripwire
trithing122811773trithing
trophic14311033trophi_c
trophied1437643trophied
trophies13413673trophies
trophying1844713trophying
tropin83316753trop_in_
tropines102214923trop_ines
tropins93116313trop_ins
trothing122410843trothing
trotline8310023trotline
trypsin1245113trypsin_
trypsins1344903trypsins
tumpline1237113tumpline
turophile1475883turophile
urethane1145433urethane

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.436409841.7
2DLD Change Limit1461621206.62322068.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.10525150.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.