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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
trephines144848(None) 
trephine1338931trephine_
trephined1544901trephined
repines94927382_rep_ines
reshines112615442_reshines
traplines11310352traplines
trophies13413672trophi_es
tropines102214922trop_ines
archines133815253ar_chines
atrophies14410093atrophi_es
atropines1148883atrop_ines
camphines1847563camphines
creatines112814433creatines
dauphines1544343dauphines
erepsins1037443erepsin_s
erewhiles1563173erewhiles
errhines1136403er_rhines
eyeshines1544253eyeshines
graphites1546823graphites
graplines1237353graplines
morphines1648223morphines
orpines94414793or_p_ines
pepsines1239883_pepsines
preppies1149673preppi_es
preppiness1344423preppiness
preprices1569263preprices
preprints1347473preprints
propines122618933prop_ines
psephites1643843psephites
raphides14188393_raphides
rapines95120863_rap_ines
reclines103718543_reclines
redlines93916083_redlines
refines105426343_re_fines
rehinges1248403_re_hinges
rehires105016113_re_hires
relines75331323_re_lines
repaints1038483_repaints
repine85627813_rep_ine_
repined104918773_rep_ined
repiner94816903_rep_iner
repiners103913433_rep_iners
repins84924313_rep_in_s
replies94521043_repli_es
reprices122913353_reprices
reprints1039903_reprints
reprises102615463_reprises
reptiles103913063_reptiles
reshine102816943_reshine_
reshined123011123_reshined
rethinks1576033_rethinks
retines75134673_re_tines
rexines144719153_re_xines
tapelines1138443tapelines
techies12513603t_echi_es
teethings1344233teethings
telephones1545683telephones
tephrites1446313t_ephrites
teredines1049453teredines
terpenes102111563terp_enes
terrines82117523t_errines
thebaines1454943thebaines
theines104013233the__ines
threonines1344543threonines
tiepins939463tiep_in_s
toplines102412563t_oplines
tramlines1139823tramlines
trapline10411863trapline_
trappings14265753trappings
trashiness1346443trashiness
treaties8316983treati_es
treatises9310373treatises
trellises947023trellises
trendies9312213trendi_es
trendiness1146223trendiness
trepangs11205403trep_angs
trepanned1243913trepanned
trepanner1143523trepanner
trepanners1243073trepanners
trepans92311593trep_an_s
trephining1644933trephining
triazines1847543triazines
trichinas1446043trichinas
trichites1448883trichites
trines64132563tr___ines
triplanes1148803triplanes
triplites1148283triplites
trippings14225723trippings
triptanes1147463triptanes
tripwires1443283tripwires
trithings13246603trithings
trophied1437643trophi_ed
tropine93116653trop_ine_
tropins93116303trop_in_s
trotlines939103trotlines
trypsins1344893trypsin_s
tumplines1346023tumplines
turophiles1565983turophiles
urethanes1245163urethanes

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641997.00021234.4
3Display Results99990.0462152.2
 (SQL Overall)178691997.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.