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

112 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
enwrap118521(None) 
entrap8710561entrap
enwraps1284831enwraps
inwrap11115901inwrap
unwrap11126321unwrap
bewrap13157052bewrap
engram9310652engram
enrapt8313012en_rapt
entraps9109762entraps
inwraps12105252inwraps
rewrap11127532rewrap
unwraps1255512unwraps
wrap96821972__wrap
anorak1038923anorak
antra56521923antra_
antral65719413antral
anural65714743anural
anuran64313243anuran
bewraps14135403bewraps
bewrapt14147133bewrapt
bewray14147733bewray
cantrap113310273cantrap
centra84113883centra_
central93114473central
crap85731843__crap
dewlap1264843dewlap
earlap837183earlap
earwax1664733earwax
encamp1235943encamp
enclasp1145843enclasp
encrypt1445323encrypt
endear74110013endear
endrin7312403endrin
enema7612743enema_
enemas8812003enemas
energy10137513energy
enframe1247363enframe
engraft11118613engraft
engrail846253engrail
engrain838343engrain
engrams1038073engrams
engrave1137133engrave
ennead736253ennead
enorm74415633enor_m
enrage72715073en_rage
enrol51014283en_rol
entera64216833entera_
enteral73516433enteral
enthral103410933enthral
entia5318203entia_
entrain7313073entrain
entrant7318873entrant
entreat7315263entreat
entree61817883entree
entropy1247353entropy
entry82414263entr_y
enure53520223enur_e
enured73315333enured
enures63919713enures
enwind10298083enwind
enwomb1344973enwomb
enwrapped1742793enwrapped
era35741503e__ra_
eras45441503e__ras
escarp10449003escarp
estral64716513estral
estray95713333estray
extra1239003extra_
extras13310223extras
eyra76217553e_yra_
eyras84715923e_yras
frap95925813__frap
genera71211713genera_
general81010933general
genipap1243123genipap
infra838643infra_
inward10310333inward
knap105815403kn__ap
mantrap11379823mantrap
menorah1247933menorah
nap56753203_n__ap
neap66927013_n_eap
neural6311993neural
onward1039053onward
prewrap14104973prewrap
rap56261963___rap
rewraps12136563rewraps
rewrapt12138113rewrapt
riprap1055513riprap
satrap86212553satrap
scrap97120403_scrap
senora63216153senora_
senoras72714953senoras
snap65727033sn__ap
sneap75514823sn_eap
snowcap1442823snowcap
strap77925263_strap
swap95925433_sw_ap
trap67532803__trap
uncap9312283un_cap
undrape1049333undrape
undraw1037813undraw
unrip72012863un_rip
unsnap836203unsnap
unstrap946783unstrap
unwary1239823unwary
ventral103612173ventral
wap86553373__w_ap
warp95635003__warp
whap125119643__whap
wraps105617153__wraps
wrapt105123183__wrapt

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161125.65319939.1
3Display Results1121120.0333393.9
 (SQL Overall)1786911125.82930655.5
 
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.