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

221 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
trepang1025729(None) 
trepan82511671trepan_
trepangs11205401trepangs
trepans92311591trepans
creping122913652creping
rehang1039822_rehang
repand95316062_repand
trapan82412972trapan_
trapans92812462trapans
treeing83414302treeing
arepa75615563arepa__
arepas85515703arepa_s
beeping124013913beeping
brewing133411153brewing
cleping123310423cleping
craping124018713craping
creeping133310103creeping
crepon1039943crepon_
crepons1139323crepons
crewing133212633crewing
defang1137753_defang
draping114213353draping
dreeing94311183dreeing
erelong835593erelong
firefang1543923firefang
firepan1236983firepan_
firepans1347153firepans
freeing113713913freeing
frypan1434543frypan_
frypans1544053frypans
greeing93613783greeing
greying124110893greying
griping113012063griping
groping113313103groping
jeeping174010333jeeping
keeping144012543keeping
orang65119943or__ang
oregano846253oregano
pang75336293___pang
peeping123615213peeping
penang92511113_penang
prang84820323pr__ang
preeing103817673preeing
preman104117453preman_
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
preparing14311643preparing
prepave14228873prepave
prepaving1787233prepaving
prepay13310313prepa_y
prepaying1747973prepaying
prepays1437483prepays
preplan1149953preplan_
preplans1249613preplans
preplant12712913preplant
prepping12309763prepping
prepreg12165963prepreg
presong1039843presong
preying133114553preying
probang12278383probang
propane112716153propane
rang56939163_r__ang
raping94829853_raping
reaping103621213_reaping
recane83022873_recane
recant83228683_recant
redan66125013_redan_
redans75421023_redans
reding83825563_reding
rehangs1137563_rehangs
rehung1036343_rehung
reland75920433_reland
reman75730153_reman_
remand95618963_remand
remans84823003_remans
repack142412163_repack
repaid94716323_repaid
repaint9318363_repaint
repair84011463_repair
repanel939963_repanel
repark123511713_repark
repass84114703_repass
repast83520633_repast
repave114813873_repave
repaving142810743_repaving
repay104818453_repa_y
repaying142712393_repaying
repays113813973_repays
repeg84015053_rep_eg
repent84728873_repent
repin75324703_repin_
repine85627813_repine
repins84924313_repins
replan83215823_replan_
replans92814943_replans
replant93318533_replant
repping123314983_repping
reptant92817073_reptant
repugn946493_repugn
reran57329103_reran_
resprang11175843_resprang
retag63618413_reta_g
rewan85623663_rewan_
riping93821613_riping
roping94023023_roping
seeping103817913seeping
shebang1334843shebang
spang84919733__spang
steeping113412583steeping
strang75718313str__ang
straphang15113923straphang
strewing12289853strewing
striping112612523striping
taipan82410663taipan_
taipans9269553taipans
tampan102512323tampan_
tampans113310983tampans
tamping122815813tamping
tang56138673t___ang
taping94222393t_aping
tapping123317133tapping
tarpan82814293tarpan_
tarpans92513533tarpans
teeing73916973t_eeing
teeming103513093teeming
temping122710693temping
tenant6322473t_enant
teopan839353teopan_
teopans939203teopans
tepa66021683t_epa__
tepal76319583t_epa_l
tepals85415043t_epals
tepas76521683t_epa_s
terming104016003terming
terpene92310863terpene
terrane72814233terrane
tetany959843t_etany
tewing103914823t_ewing
theming133610473theming
threaping15106113threaping
threeping15104803threeping
tieing73518763tie_ing
tiepin839343tiepin_
tiepins939463tiepins
tiering8315253tiering
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tipping122814973tipping
toeing74418473toe_ing
toping94122993t_oping
topping123514623topping
tracing103720153tracing
trading93517973trading
tramping132711273tramping
trank96222423tr__ank
tranq145416893tr__anq
trans54933043tr__ans
trapping132911393trapping
tread64821703tre_a_d
treading103515333treading
treads74817923tre_ads
treat56240353tre_a_t
treating92519613treating
treats64821693tre_ats
treaty94414353tre_aty
trebling1139873trebling
treen55622753tre_en_
treens65317873tre_ens
trefah1235093trefa_h
trehala1045953trehala
trekking1235543trekking
trenail7410813trenail
trend64817453tre__nd
trending103012833trending
trepanned1243913trepanned
trepanner1143523trepanner
trepanning1344153trepanning
trephine1338933trephine
trepid9310083trep_id
trepidant1244663trepidant
trespass1043383trespass
tricing103417353tricing
trining82919213trining
tripack1565673tripack
tripart9311433tripart
triplane1039113triplane
tripling112712553tripling
tripping133210923tripping
triptan947543triptan_
triptane1047563triptane
triptans1047363triptans
troking123514103troking
troland837543troland
tromping13319603tromping
trooping112710283trooping
tropin83316753tropin_
tropine93116653tropine
tropins93116313tropins
trouping11249503trouping
trowing113413703trowing
truant6315783tr_uant
trucing103211843trucing
trueing83410183trueing
truing73913933tr_uing
trumping13308733trumping
trying104214073tr_ying
tumping123114243tumping
tupping123411663tupping
twang94511853t__wang
tympan13257013tympan_
tympana14255853tympana
tympani14275923tympani
tympano14245283tympano
tympans14236813tympans
tympany17254603tympany
typing124110583t_yping
urping93914053ur_ping
weeping133613673weeping
wrang94716113wr__ang

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.423422437.4
2DLD Change Limit1340272215.95322514.2
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.45227695.4
 
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.