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

256 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
crambos133678(None) 
crambes1339961crambes
crambo1238041crambo_
cramboes1436541cramboes
ambos95321252__ambos
cameos105818002c_ameos
camos95927612c_am_os
campos125217952c_ampos
carbos105122262c_arbos
combos125316612c_ombos
crabs95421392cra_b_s
crambe1239072cramb_e
crampon1336942crampon
crampons1436642crampons
cramps125615562cram_ps
crams96229152cram__s
crumbs12409232crumb_s
mambos125414492_mambos
sambos104315192_sambos
abos67734413__a_bos
alamos8415003alam_os
ambo88225143__ambo_
ammos94815823__ammos
arames84622573aram_es
aramids102810513aramids
bamboo12310013_bamboo
bamboos1348753_bamboos
bimbos124610523_bimbos
bramble133710033bramble
brambles14308973brambles
brambly16296253brambly
bravos114711393bra_vos
bromos104213313brom_os
cabob114616813c_a_bob
cabobs124311893c_a_bobs
cabs86739423c_a_b_s
cacaos104616183c_acaos
calos74431903c_a_los
camas96333523c_am_as
camass104114183c_amass
camber124418483c_amber
cambers134017443c_ambers
cambia124913153c_ambia
cambism1538033c_ambism
cambist13312113c_ambist
camels105217083c_amels
cameo95924993c_ameo_
cames97047313c_am_es
camion103917193c_amion
camions113916133c_amions
camo85731753c_am_o_
campo115219763c_ampo_
camps116330263c_am_ps
campus125213923c_ampus
cams87047283c_am__s
cansos84915383c_ansos
cantos84826973c_antos
capos94826073c_a_pos
carabaos1238083carabaos
caramba1336893caramb_a
carambola1542853carambola
carambolas1643373carambolas
caramels1238803caramels
carbo94923843c_arbo_
carbon104919043c_arbon
carbons115418943c_arbons
carboy134914183c_arboy
carboys144711783c_arboys
carbs96031463c_arb_s
cargos94619183c_argos
caribes113715643caribes
caribou1156993caribou
caribous1258823caribous
carobs104818103carob_s
ceramals1246513ceramals
ceramics1446803ceramics
chaebol1444943chaebol
chaebols1544723chaebols
chamber164011063chamber
chambers173410623chambers
chamiso14348653chamiso
chamisos15307423chamisos
chamois143512193chamois
champs154915683cham_ps
chams126028503cham__s
chaos105622863cha__os
charros124312143charros
chemos13311723chem_os
chimbs153910303chimb_s
chromos142610273chrom_os
clamber133311743clamber
clambers144211293clambers
clamor1049453clam_or
clamors11710093clamors
clamps124515083clam_ps
clams95127673clam__s
claros84015113cla_ros
climbs12498723climb_s
coalbox1844113coalbox
combes125321733c_ombes
combo114519433c_ombo_
combs116122963c_omb_s
compos124818803c_ompos
coombes133810663coombes
coombs124210193coomb_s
corantos10310103corantos
corymbose1842303corymbose
corymbous1842733corymbous
corymbs1633453corymb_s
cosmos10311753cosm_os
craals84113303cra_als
crab85727673cra_b__
crabbed14388873crabbed
crabber133810733crabber
crabbers14358753crabbers
crabby15346753cra_bby
cracks144817003cra_cks
cradles103114133cradles
crafts115312743cra_fts
crags85622573cra__gs
crakes124921813cra_kes
cram85635493cram___
crammed143710123crammed
crammer134010963crammer
crammers14369353crammers
cramoisy1543703cramoisy
cramp115120693cram__p
cramped144712183cramped
crampit1338863crampit
crampits1436273crampits
crampoon1444543crampoon
crampoons1544063crampoons
crampy154710993cram_py
cranes84330753cra_nes
crankous1435973crankous
cranks125015313cra_nks
crannog1044243crannog
crannogs1143783crannogs
crapes104727693cra_pes
craps95328643cra__ps
crases85532313cra_ses
crashes124618403crashes
crasis85020473cra_sis
crass76328043cra__ss
craters95021893craters
crates85736063cra_tes
craton84517193cra_ton
cratons94316033cratons
cravats1237403cravats
cravens124010123cravens
cravers124416563cravers
craves115825393cra_ves
crawls114712083cra_wls
craws105723123cra__ws
crayon114110003cra_yon
crayons12439233crayons
crazes174720133cra_zes
crazies183413853crazies
creamers124111313creamers
creams104715253cream__s
credos94612853cr_edos
cremes104517993crem_es
cribs94516753cr_ib_s
crimes105521583crim_es
crimps124613453crim_ps
crimson1135643crimson
crimsons1245633crimsons
crumb114313593crumb__
crumbed14378473crumbed
crumber13339643crumber
crumbers14338243crumbers
crumble133410403crumble
crumbles14329683crumbles
crumbly16347523crumbly
crumbum1543743crumbum
crumbums1642733crumbums
crumby15408113crumb_y
crumps124514343crum_ps
cryptos14337213cryptos
cuatros938273cuatros
curacaos1244923curacaos
drabs85119673dra_b_s
dramas95814653dram_as
drams86025833dram__s
dumbos114111083_dumbos
flambes14419503flambes
framboise1642733framboise
framers125113823framers
frames115119863fram_es
gambas115817513_gambas
gambes116318313_gambes
gambol1138223_gambol
gambols1238593_gambols
gambs105721123_gamb_s
gombos114311093_gombos
grabs85719693gra_b_s
gramas94317203gram_as
grammas12499773grammas
grammes123611323grammes
grampas12399253grampas
gramps114114273gram_ps
grampus12356313grampus
grams85327313gram__s
gumbos114610873_gumbos
iambs95815063_iamb_s
iambus10468903_iambus
jambes175914053_jambes
jambs166014623_jamb_s
jumbos17379123_jumbos
lambs95921413_lamb_s
limbos104712143_limbos
mambas125716243_mambas
mambo115215743_mambo_
mamboes135011823_mamboes
paramos113213513param_os
prams96125513pram__s
praos74923563pra__os
primos104514423prim_os
promos105116423prom_os
rabbis102613163_rabbis
radios74018673_radios
rambla103510933_rambla
ramblas112710263_ramblas
ramble104519973_ramble
rambles113118313_rambles
ramees84620893_ramees
ramets83517393_ramets
ramies84630463_ramies
ramose8314403_ram_ose
ramous8417113_ramous
ramps96224633_ram_ps
ramrod936833_ramrod
ramrods1036583_ramrods
rams65950773_ram__s
ramson8310463_ramson
ramsons939563_ramsons
ramus76418283_ram_us
ratios64922673_ratios
ratos55528763_ra_tos
romeos84013173_romeos
rumbas102512013_rumbas
sambas104219263_sambas
sambo95118013_sambo_
scramble14177253scramble
scrambles15146383scrambles
scrams105216623scram__s
shammos14307203shammos
shamos114216983sham_os
sjambok2242303sjambok
sjamboks2342233sjamboks
spambot1345913spambot
spambots1443313spambots
tramels93812493tramels
tramps105114453tram_ps
trams75327673tram__s
umbos94613073__umbos

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272567.15618729.3
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.65523343.0
 
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.