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

172 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
cramboes143654(None) 
crambes1339961cramb_es
crambos1336781crambo_s
brambles14308972brambles
crambe1239072cramb_e_
crambo1238042crambo__
crampons1436642crampons
crumbles14329682crumbles
mamboes135011822_mamboes
rambles113118312_rambles
scrambles15146382scrambles
ambles105121863__ambles
ambones11312683__ambones
ambos95321253__ambo_s
arables91814973ara_bles
arames84622573aram__es
bamboos1348753_bamboos
bimboes13498733_bimboes
brabbles11349753brabbles
bramble133710033bramble_
brambled15316733brambled
bravoes12418533bra_voes
brumbies1436533brumbies
cabbies133115163c_abbies
cables104527553c_a_bles
cabobs124311893c_a_bobs
camases114216343c_amases
camber124418483c_amb_er
cambers134017443c_ambers
cameoed1238383c_ameoed
cameos105818003c_ameo_s
cames97047313c_am__es
camions113916133c_amions
camises114218463c_amises
cammies134016483c_ammies
camos95927613c_am_o_s
campos125217953c_ampo_s
canoes84725883c_a_noes
carambola1542853carambola
carambolas1643373carambolas
carbons115418943c_arbons
carbos105122263c_arbo_s
carboys144711783c_arboys
cargoes104415223c_argoes
caribes113715643carib_es
caribous1258823caribous
carmines123617863carmines
ceramides1447453ceramides
chaebols1544723chaebols
chamades16138653chamades
chamber164011063chamb_er
chambers173410623chambers
chamises153513313chamises
chammies172910163chammies
chamois143512193cham_ois
clambakes1943313clambakes
clamber133311743clamb_er
clambers144211293clambers
clamors11710093clam_ors
claroes93113733cla_roes
coalboxes2043683coalboxes
combes125321733c_omb_es
combos125316613c_ombo_s
coombes133810663coomb_es
corantoes1147653corantoes
corymbose1842303corymbose
corymbous1842733corymbous
crabbed14388873cra_bbed
crabber133810733cra_bber
crabbers14358753crabbers
crabbier14326803crabbier
crabbiest1535623crabbiest
crabs95421393cra_b__s
crackles164111273crackles
cradles103114133cra_dles
crakes124921813cra__kes
crammed143710123cram_med
crammer134010963cram_mer
crammers14369353crammers
cramoisy1543703cram_oisy
cramped144712183cram_ped
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
crampon1336943crampo_n
crampoon1444543crampoon
crampoons1544063crampoons
cramps125615563cram__ps
crams96229153cram___s
cranches153114543cranches
cranes84330753cra__nes
crankles143510153crankles
crankous1435973crankous
crannies10313013crannies
crannoges1244243crannoges
crannogs1143783crannogs
crapes104727693cra__pes
crappies142911153crappies
crases85532313cra__ses
crashes124618403cra_shes
cratches153012543cratches
crates85736063cra__tes
cratons94316033cra_tons
craves115825393cra__ves
crayons12439233cra_yons
crazes174720133cra__zes
crazies183413853cra_zies
cremates124216003cremates
cremes104517993crem__es
crimes105521583crim__es
crimples14308963crimples
crimsons1245633crimsons
crumbed14378473crumb_ed
crumber13339643crumb_er
crumbers14338243crumbers
crumbier1456363crumbier
crumbiest1536253crumbiest
crumble133410403crumble_
crumbled15357443crumbled
crumbs12409233crumb__s
crumbums1642733crumbums
crummies1437643crummies
crumples14348813crumples
drabbles13308523drabbles
drawbores1542643drawbores
drumbles13277723drumbles
flambes14419503flamb_es
framboise1642733framboise
framboises1742693framboises
frames115119863fram__es
gambes116318313_gamb_es
gambles124016203_gambles
gamboges1435653_gamboges
gambols1238593_gambols
grabbles13339893grabbles
grammes123611323gram_mes
grumbles13288873grumbles
hambones1539673_hambones
jambes175914053_jamb_es
lambies113015113_lambies
mamboed14417623_mamboed
mambos125414493_mambo_s
preambles1545333preambles
rabbies113416053_rabbies
rabbles113517973_rabbles
rabies85226023_ra_bies
ramblas112710263_ramblas
ramble104519973_ramble_
rambled123913523_rambled
rambler113313263_rambler
ramblers124010373_ramblers
ramees84620893_ram_ees
ramies84630463_ram_ies
ramose8314403_ram_ose
ramous8417113_ram_ous
rampoles1238893_rampoles
ramrods1036583_ramrods
ramsons939563_ramsons
rumbles114018393_rumbles
sambos104315193_sambo_s
scrabbles15206283scrabbles
scramble14177253scramble_
scrambled16164813scrambled
scrambler15165043scrambler
scramblers16183543scramblers
shambles15159043shambles
sjamboks2342233sjamboks
spambots1443313spambots
tramples122610203tramples
trembles1237353trembles
trombones1345363trombones
wambles143714023_wambles

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.436409841.7
2DLD Change Limit1461621727.08020644.4
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.59223536.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.