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

201 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
rampole113969(None) 
rampoles1238891rampoles
amole75724592_am_ole
ample94720302_amp_le
ampoule11116602_ampoule
ampule10710612_ampule
armhole1236942armhole
maypole1446382maypole
ramble104519972ram_ble
ramose8314402ram_ose
rampage1237452rampage
rampike1536602rampike
rathole10312052rathole
rimple103814582rimp_le
rumple103913012rump_le
sample104215012samp_le
tadpole1036142tadpole
trample11299702tramp_le
amble95924643_am_ble
amoles84122193_am_oles
ampere10514413_ampere
ampler104313303_amp_ler
amply125012913_amp_ly
ampoules1275853_ampoules
ampul91110853_ampul_
ampules1189433_ampules
ampuls1098893_ampuls
anole55330373_a_nole
apple94517673_a_pple
appose10411993_appose
areole61017283_areole
armholes1347383armholes
azole145118033_a_zole
beanpole1244333beanpole
braciole1246973braciole
bramble133710033bram_ble
cajole154011183ca_jole
camisole1246173camisole
camphol1645793camphol_
camphols1746243camphols
campily1638273campily
campo115219763campo__
campong14318123campong
camporee1449343camporee
campos125217953campo_s
campout13412853campout
capote10315733ca_pote
cariole9818343cariole
carpale113414353carpale
compile13312443compile
compone136517193compone
compose135716663compose
compote135616463compote
crampon1336943crampo_n
crampons1436643crampons
crampoon1444543crampoon
crapola1136913cra_pola
crimple13408693crimp_le
crumple13368363crump_le
damply14337893damp_ly
dapple1138853da_pple
dariole8711163dariole
dimple113512793dimp_le
dipole91112853_dipole
empale102611263_empale
example1844283examp_le
flagpole1443583flagpole
framable1537573framable
gamble115417183gam_ble
gamboge1335583gamboge
gambol1138223gambol_
gamboled1435873gamboled
gambols1238593gambols
grapple12378003gra_pple
hambone1439313hambone
haole84820083ha__ole
impale102811663_impale
impone103011863_impone
impose103113053_impose
kampong16294933kampong
lampoon11267193lampoon
manhole12311343manhole
maple95521143ma_p_le
maypoles1545993maypoles
mole66251833__m_ole
namable11312333namable
osmole8128513osm_ole
pamphlet1745733pamphlet
pappose1047413pappose
papule102212133pa_pule
parole84425253pa_role
pimple123512963pimp_le
pole65951303___pole
rabble103818243ra_bble
rackle123917293ra_ckle
raddle84816173ra_ddle
radiale83813523radiale
radicle103510713radicle
radome9511873ra_dome
raffle123910703ra_ffle
raggle83712883ra_ggle
rale45050563ra___le
ramal74622243ram_al_
ramate83921683ram_ate
rambla103510933ram_bla
rambled123913523ram_bled
rambler113313263ram_bler
rambles113118313ram_bles
ramee74633853ram__ee
ramie75027823ram__ie
ramilie9310283ramilie
ramillie1045863ramillie
ramona8412413ram_ona
ramous8417103ram_ous
ramp85934003ramp___
rampaged1434103rampaged
rampager1344453rampager
rampages1336673rampages
rampant11312173rampant
rampart11311993rampart
ramped114617903ramp_ed
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
rampions12248023rampions
ramps96224633ramp__s
ramrod936833ramro_d
ramrods1036583ramrods
ramson8310463ramso_n
ramsons939563ramsons
ramtil8311023ramtil_
ramtils938413ramtils
ramulose1044313ramulose
rankle103414883ra_nkle
ranpike1335933ranpike
rape65041633ra_p__e
raphae114311733ra_phae
raphe104916423ra_p_he
rapine85023083ra_pine
rappee103618673ra_ppee
rappel104211953rappel_
rappeled1335003rappeled
rappels11448803rappels
rapport11311223rapport
raptly11338913ra_ptly
rassle63813203ra_ssle
ratable91717553ratable
ratholes11312413ratholes
rattle64717613ra_ttle
ravioli1055613ravioli
redpoll1045043redpoll
reimpose1245623reimpose
remold93412973rem_old
remote84222603rem_ote
remove116115573rem_ove
repoll8410793r_epoll
repose84121413r_epose
resample1244673resamp_le
resole64624183r_esole
respoke134311283respoke
rhamnose13103463rhamnose
rimose8310593rim_ose
rimpled123311423rimp_led
rimples113114223rimp_les
ripple103413913r_ipple
rissole739783rissole
rocambole1542213rocambole
role45851823r___ole
rumble103718813rum_ble
rumpled123810013rump_led
rumples113313133rump_les
rumply13348573rump_ly
safrole1037253safrole
sampled123410783samp_led
sampler113212013samp_ler
samples112815453samp_les
sapote8314353sa_pote
semple103212753semp_le
simple104315173simp_le
tadpoles1135953tadpoles
tamable11312843tamable
tamale83717393tam_ale
tampala1136613tampala
tampon102911233tampo_n
tamponed1336023tamponed
tampons112711553tampons
taphole1239773taphole
temple102811333temp_le
trampled13247903tramp_led
trampler12278003tramp_ler
tramples122610203tramp_les
trampoline1444523trampoline
trappose1245813trappose
vacuole1245373vacuole
vamoose1235863vamoose
vamose1159283vam_ose
vampire14296673vampire
variole10711593variole
wamble134415753wam_ble
wimple133611363wimp_le
zeppole2043493zeppole

Search took 10 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.1561145455.1
2DLD Change Limit1340272019.23614511.4
3Display Results2012010.0762644.7
 (SQL Overall)1786912019.46818873.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.