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

185 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
rampoles123889(None) 
rampole1139691rampole_
amoles84122192_am_oles
ampoules1275852_ampoules
ampules1189432_ampules
armholes1347382armholes
maypoles1545992maypoles
rambles113118312ram_bles
rampages1336672rampages
rampikes1635392rampikes
ratholes11312412ratholes
rimples113114222rimp_les
rumples113313132rump_les
samples112815452samp_les
tadpoles1135952tadpoles
tramples122610202tramp_les
ambles105121853_am_bles
ambones11312683_ambones
amole75724593_am_ole_
amperes11313983_amperes
ample94720303_amp_le_
ampler104313303_amp_ler
amplest11312333_amp_lest
ampoule11116603_ampoule_
ampule10710613_ampule_
ampuls1098893_ampul_s
anoles64827423_a_noles
apples104315763_a_pples
apposes11511473_apposes
areoles71016953_areoles
armhole1236943armhole_
azoles154614613_a_zoles
beanpoles1344313beanpoles
bracioles1346493bracioles
brambles14308973bram_bles
cajoles163712103ca_joles
camisoles1345573camisoles
camphols1746243camphol_s
campongs15356123campongs
camporee1449343camporee
camporees1546103camporees
campos125217953campo__s
campouts1436823campouts
campuses1437773campuses
capotes11314643ca_potes
carioles10817063carioles
compiles14311983compiles
composes145017113composes
compotes144716513compotes
cramboes1436543crambo_es
crampons1436643crampo_ns
crampoons1544063crampoons
crapolas1247403cra_polas
crimples14308963crimp_les
crumples14348813crump_les
dapples1238993da_pples
darioles9710693darioles
dimples122813213dimp_les
dipoles101013753_dipoles
empales112411433_empales
examples1944313examp_les
flagpoles1543413flagpoles
gambles124016203gam_bles
gamboges1435653gamboges
gamboled1435873gamboled
gambols1238593gambol_s
grampuses1442973grampuses
grapples13348123gra_pples
hambones1539673hambones
haoles94919803ha__oles
impales113311763_impales
impones112712253_impones
imposes113213683_imposes
kampongs17293033kampongs
lampases1267293lampases
lampoons12266863lampoons
mamboes135011823mambo_es
manholes13311183manholes
maples104819423ma_p_les
maypole1446383maypole_
moles74747923__m_oles
osmoles9138363osm_oles
pamphlet1745733pamphlet
pamphlets1842753pamphlets
papules112411573pa_pules
paroles95025883pa_roles
pimples133012423pimp_les
poles75351003___poles
rabbles113517973ra_bbles
raddles93615703ra_ddles
radicles11249693radicles
radomes10311043ra_domes
raffles133611843ra_ffles
raggles93813283ra_ggles
rales54947493ra___les
ramblas112710263ram_blas
ramble104519973ram_ble_
rambled123913513ram_bled
rambler113313263ram_bler
ramblers124010373ram_blers
ramees84620893ram__ees
ramies84630463ram__ies
ramifies13310503ramifies
ramilies10311833ramilies
ramillies1146123ramillies
ramonas9311093ram_onas
ramose8314403ram_ose_
ramous8417103ram_o_us
rampage1237453rampage_
rampaged1434103rampaged
rampager1344453rampager
rampagers1443863rampagers
ramparts1245583ramparts
ramped114617903ramp__ed
rampike1536603rampike_
rampions12248023rampions
ramps96224633ramp___s
ramrods1036583ramro_ds
ramsons939563ramso_ns
ramtils938413ramtil_s
ramulose1044313ramulose
ramulous1045883ramulous
rankles113114543ra_nkles
ranpikes1435643ranpikes
rapes75740723ra_p__es
raphes115117453ra_p_hes
rapines95120863ra_pines
rappees113611453ra_ppees
rappeled1335003rappeled
rappels11448803rappel_s
rapports1245963rapports
rassles73513923ra_ssles
ratables10159723ratables
rathole10312053rathole_
rattles73217303ra_ttles
raviolis1146103raviolis
redpolls1144013redpolls
reimposes1345473reimposes
remolds10299703rem_olds
remotes94521613rem_otes
removes124514713rem_oves
repolls939053r_epolls
reposes94021263r_eposes
resamples1344713resamp_les
resoles73823653r_esoles
rhamnoses14104183rhamnoses
rimple103814583rimp_le_
rimpled123311423rimp_led
ripples113513293r_ipples
rissoles839113rissoles
rocamboles1652303rocamboles
roles56747983r___oles
rumbles114018393rum_bles
rumple103913013rump_le_
rumpled123810013rump_led
rumpless12256543rump_less
rumpuses1235163rumpuses
safroles1136933safroles
sample104215013samp_le_
sampled123410783samp_led
sampler113212013samp_ler
samplers12299403samp_lers
sapotes9313933sa_potes
simples113014943simp_les
tadpole1036143tadpole_
tamales93216143tam_ales
tampalas1245473tampalas
tamponed1336023tamponed
tampons112711553tampo_ns
tapholes1339623tapholes
temples112610893temp_les
trample11299703tramp_le_
trampled13247903tramp_led
trampler12278003tramp_ler
tramplers13305873tramp_lers
trampolines1543873trampolines
vacuoles1345013vacuoles
vamooses1345523vamooses
vamoses1239143vam_oses
vampires15226033vampires
varioles11711123varioles
wambles143714023wam_bles
wampuses1534113wampuses
wimples143311173wimp_les
zeppoles2143583zeppoles

Search took 9 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.1561145455.1
2DLD Change Limit1461621857.75318852.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.98522378.3
 
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.