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

153 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
traipsed113475(None) 
traipse935871traipse_
traipses1036871traipses
braised104014802brai_sed
praised104214812prai_sed
raised76120332_rai_sed
traiked123310452trai_ked
trailed83415672trai_led
trained84117202trai_ned
tramped124312432tramp_ed
trampled13247902trampled
trapesed1136472trapesed
trapped124512212tra_pped
tripled104113832tr_ipled
tripped123911692tr_ipped
braided114013213brai_ded
brailed103914013brai_led
brailled1147193brailled
brained103816103brai_ned
braise84318753brai_se_
braises93818873brai_ses
brassed103612373bra_ssed
bruised10389503brui_sed
cramped144712183cramp_ed
craped116120533cra_p_ed
crapped143912633cra_pped
crisped124010113cr_isped
cruised103710223crui_sed
drained93713253drai_ned
draped105314363dra_p_ed
dripped13408083dr_ipped
eclipsed1343483eclipsed
elapsed1056113ela_psed
erased74816763era__sed
fraise94214913frai_se_
fraises104215693frai_ses
frapped15318853fra_pped
grained93814273grai_ned
graphed1498473gra_phed
grappled14336093grappled
grasped11409063grasp_ed
grassed93812793gra_ssed
griped104114713gr_ip_ed
gripped13419343gr_ipped
irised73913153ir_i_sed
lapsed94712583_la_psed
liaised837113liai_sed
outraised1039243outrai_sed
praise84419413prai_se_
praiser93413943prai_ser
praises94121113prai_ses
prised94322203pr_i_sed
prissed103311263pr_issed
raided85017703_rai_ded
railed74727543_rai_led
rained75024603_rai_ned
raise54828053_rai_se_
raiser66620103_rai_ser
raises64826543_rai_ses
ralphed1334363_ralphed
ramped114617903_ramp_ed
raped85334623_ra_p_ed
rapped114122683_ra_pped
rased65033933_ra__sed
rasped94715203_rasp_ed
reraised9312363rerai_sed
rinsed75016353_r_insed
riped85226433_r_ip_ed
ripped114419013_r_ipped
strained9412253strai_ned
strapped1357823stra_pped
striped105214363str_ip_ed
stripped1357093str_ipped
tailed74424663t_ai_led
tainted83512423t_ainted
taliped1078203talip_ed
tamped114317043t_amp_ed
taped85327423t_a_p_ed
tapises92914013t_apises
tapped113820053t_a_pped
tariffed1533723tariffed
tawsed10499743t_a_wsed
teased74721153tea__sed
tipped114418263t__ipped
traced94821583tra__ced
trachled1438313trachled
tracked143716133tra_cked
traded85717683tra__ded
traduced1244673traduced
traiks104013713traiks__
trailer73015393trai_ler
trailered1045393trailered
trailhead1343433trailhead
trails64622513trails__
trailside1044523trailside
trainee72817793trai_nee
trainees82712073trainees
trainer73316793trai_ner
trainmen1046163trainmen
trains64725343trains__
traipsing1235073traipsing
traits65121983traits__
trameled11309073trameled
trammed123810713tra_mmed
tramper113812163tramp_er
trampier12318243trampier
trample11299703trample_
trampler12278013trampler
tramples122610203tramples
tramps105114453tramps__
tranced104414173tra_nced
transposed1345323transposed
trapes85024463tra_p_es
trapeses1039153trapeses
trapper113912803tra_pper
trappose1245813trappose_
traps75727483tra_ps__
trashed113514703tra_shed
trasses74819323tra_sses
traveled12349453traveled
traversed1344573traversed
trawled113411523tra_wled
tressed83714263tr_essed
triaged92810443tr_iaged
triced95518673tr_i_ced
tricked144016163tr_icked
tried65026913tr_i__ed
trifled113711963tr_ifled
trigged10359853tr_igged
trilled84116313tr_illed
trimmed12348933tr_immed
trined74920713tr_i_ned
triose64715383tr_iose_
trioses75015653tr_ioses
tripe75425383tr_ip_e_
tripes85324873tr_ip_es
triple84215923tr_iple_
triples94616873tr_iples
triplet94319213tr_iplet
triplex16447803tr_iplex
tripod9399853tr_ip_od
triposes1039973tr_iposes
tripper113711923tr_ipper
trippet113714113tr_ippet
trips74923363tr_ips__
tromped124210293tromp_ed
trooped104010723troop_ed
trouped103910983troup_ed
trumped12439713trump_ed
trussed84010033tr_ussed
unraised91811883unrai_sed
upraised11167413uprai_sed
wrapped15338023wra_pped

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 Limit1461621536.61022112.3
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.09325192.6
 
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.