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

102 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
trepangs1120540(None) 
trepang10257291trepang_
trepans92311591trepan_s
rehangs1137562_rehangs
trapans92812462trapan_s
trepan82511672trepan__
arepas85515703arepa__s
brewings14296693brewings
creping122913653creping_
crepons1139313crepon_s
defangs1235363_defangs
firefangs1643053firefangs
firepans1347153firepan_s
frypans1544053frypan_s
keepings15345943keepings
orangs74116033or__angs
oreganos945553oreganos
pangs84628663___pangs
penangs10268373_penangs
prangs94816233pr__angs
prepacks1836583prepacks
prepares122014163prepares
prepaves15189193prepaves
prepays1437483prepa_ys
preplans1249613preplan_s
prepregs13144763prepregs
probangs13256203probangs
propanes122415823propanes
recanes93222263_recanes
recants93217093_recants
redans75421023_redan_s
rehang1039823_rehang_
relands85214883_relands
remands104914883_remands
remans84823003_reman_s
repacks15269543_repacks
repaints1038483_repaints
repairs9319973_repairs
repand95316063_repan_d
repanel939963_repanel
repanels1036783_repanels
reparks13249513_reparks
repass84114703_repa_ss
repasts93611933_repasts
repaves123513653_repaves
repays113813973_repa_ys
repegs93311943_rep_egs
repents93717623_repents
repines94927383_repines
repins84924313_repin_s
replans92814943_replan_s
replants102811243_replants
repugns1035393_repugns
retags73414303_reta_gs
shebangs1443593shebangs
straphangs16123403straphangs
stripings12215203stripings
taipans9269553taipan_s
tampans113310983tampan_s
tangs65028343t___angs
tappings13267713tappings
tarpans92513533tarpan_s
tenants7311013t_enants
teopans939203teopan_s
tepals85415043t_epa_ls
tepas76521683t_epa__s
terpenes102111563terpenes
terranes82514393terranes
tetanus737933t_etanus
tiepins939463tiepin_s
toppings13286423toppings
tracings112910403tracings
tranks104017763tr__anks
tranqs155210313tr__anqs
trans54933043tr__an_s
trapan82412973trapan__
trappings14265753trappings
treads74817913tre_a_ds
treats64821693tre_a_ts
treeing83414303treeing_
treens65317873tre_en_s
trehalas1144883trehalas
trenails869843trenails
trends75513543tre__nds
trepanned1243913trepanned
trepanner1143523trepanner
trepanners1243073trepanners
trephines1448483trephines
trespass1043383trespa_ss
tripacks1664893tripacks
triplanes1148803triplanes
trippings14225723trippings
triptanes1147463triptanes
triptans1047363triptan_s
trolands936413trolands
tropines102214923tropines
tropins93116303tropin_s
truants738153tr_uants
twangs10358093t__wangs
tympans14236813tympan_s
weepings14346483weepings
wrangs104611913wr__angs

Search took 9 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.343520965.0
2DLD Change Limit1461621028.47017256.4
3Display Results1021020.0333090.9
 (SQL Overall)1786911028.84620200.2
 
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.