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

150 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
encamp123594(None) 
encamps1335421encamps
camp106336452__camp
decamp1338452decamp
encage93713502encage
encamped1535022encamped
encase83714362encase
encash11276942encash
enclasp1145842enclasp
escarp10449002escarp
scamp115717312_scamp
uncap9312282unca_p
unclamp1344992unclamp
abamp11310603_abamp
amp77541023___amp
became123213163became
becap114315053beca_p
bedlamp1464513bedlamp
bename103316073ben_ame
cam78058983__cam_
came87648753__came
camo85731753__camo
campi116217783__campi
campo115219763__campo
camps116330263__camps
campy145116183__campy
cams87047283__cams
cap76758983__ca_p
carp85139813__carp
champ145017963_champ
clamp115517653_clamp
comp106731253__comp
cramp115120693_cramp
damp96228843__damp
decamps1435643decamps
enact73525363en_act
enacts84012973enacts
enamel81210113en_amel
enamor838753en_amor
enate54428153en_ate
encaged113211083encaged
encages103313783encages
encamping1645233encamping
encased103512313encased
encases93116053encases
enchain1248853enchain
enchant12313113enchant
enchase1239453enchase
encina8310443encina
enclasps1245133enclasps
enclave1257533enclave
encode9310443encode
encomia1147983encomia
encore8314773encore
encrypt1445323encrypt
encyst1136203encyst
endash10297123endash
endgame1145233endgame
endocarp1343733endocarp
enema7612743en_ema
enemas8812003enemas
enemy1059993en_emy
enface112510353enface
enflame1236573enflame
enframe1247363enframe
engage82812103engage
engram9310653engram_
engrams1038073engrams
enhalo987563enhalo
enigma935643enigma
enlace82213233enlace
enorm74415643enorm_
enrage72715073enrage
enrapt8313013enrapt
ensample1242983ensample
entail61114343entail
entomb1037363entomb
entrap8710563entrap
enwomb1344973enwomb
enwrap1185213enwrap
enzym1964393enzym_
enzyme2054343enzyme
enzyms2063433enzyms
epicarp1376073epicarp
escalop1144783escalop
escape103811663escape
escar74011993esca_r
escarps11397373escarps
escars83913133escars
exam132514623e_xam_
exams14199083e_xams
exocarp1843853exocarp
gamp98833213__gamp
gelcap1136213gelca_p
gramp106218323_gramp
hencoop1443813hencoop
incage93513623incage
incant82418503incant
incase83615283incase
inclasp1145303inclasp
inclip1036823inclip
income10712093income
infamy1435653infamy
jicama1734883jicama
knap105815403kn_a_p
lamp86233823__lamp
minicamp16124063minicamp
nam55953393_n_am_
name65637413_n_ame
nap56753203_n_a_p
neap66927013_nea_p
oilcamp1343053oilcamp
penname11328553penname
preamp1238993preamp
ramp85934003__ramp
recap95718023reca_p
redcap1158493redca_p
rename82718813ren_ame
restamp1146483restamp
revamp1336013revamp
samp85733593__samp
scalp95217983_scalp
scam85932353_scam_
scampi12469103_scampi
scamps125014173_scamps
scams94423973_scams
scarp95724103_scarp
scaup95515993_scaup
snap65727033sn_a_p
sneap75514823snea_p
stamp95217363_stamp
sunlamp1144163sunlamp
swamp125015323_swamp
syncarp1444533syncarp
tamp86133003__tamp
tramp96319773_tramp
uncage93014873uncage
uncake122813523uncake
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unclamps1443693unclamps
unclasp1135963unclasp
unclip1046993unclip
unjam1448723unjam_
unjams1555703unjams
untame82513603untame
vamp115521543__vamp
webcam1545543webcam_
webcams1643073webcams

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.390458182.1
2DLD Change Limit1127161504.86023192.6
3Display Results1501500.0463260.9
 (SQL Overall)1786911505.29633740.7
 
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.