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

248 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
cumbias1333896(None) 
cumbia12379891cumbia_
cambia124913152cambia_
cambial134010762cambial
cobias104014982c_obias
cubbies133312882cubbies
cubics123810162cu_bics
cubits103714032cu_bits
cumbers134515392cumbers
cumins103314932cum_ins
cummins1358962cummins
gambias125010732gambias
nubias8310092nu_bias
rumbas102512012rumb_as
umbras1038642_umbras
urbias839092_urbias
ambits103713413_ambits
amias75831473_am_ias
amusias938573amusias
bias64738163___bias
brumbies1436533brumbies
bubbas94110703bu_bbas
bubbies103913513bubbies
bulbils11338333bulbils
bumbles134016843bumbles
bumboat1349023bumboat
bumboats1445183bumboats
bumelias1245063bumelias
bumkins15318013bumkins
busbies113011693busbies
cabbies133115163cabbies
cabins104418923c_abins
camails11311743camails
camas96333523cam__as
cambers134017433cambers
cambism1538033cambism
cambisms1645793cambisms
cambist13312113cambist
cambists1437023cambists
cambium1537323cambium
cambiums1644923cambiums
cambogias1643843cambogias
cambrics1645243cambrics
camelias12510293camelias
cameras11313343cameras
camisa103114323cam_isa
camisas113411923camisas
camisias12268603camisias
cammies134016473cammies
capias10318353c_apias
cardias10715093cardias
cassias93514343cassias
cebids11439173c_ebids
ceibas1038503ceib_as
cerias83321973c_erias
chias104625513c__hias
clivias1266693clivias
clumbers143910393clumbers
cobia94117513c_obia_
cobras104014193c_obras
codeias103911213codeias
comas95833003com__as
combat12316753comb_at
combats13311683combats
combers134516613combers
combes125321733comb_es
combine133014723combine
combines142814623combines
combing143714733combing
combings15348323combings
combos125316613comb_os
combs116122963comb__s
comfits14328743comfits
comics124015563com_ics
commas124814573com_mas
commies133718443commies
commits133812373commits
compas125817063com_pas
corbies113520113corbies
corbinas12229383corbinas
crumbers14338223crumbers
crumbier1456363crumbier
crumbiest1536253crumbiest
crumbing15267813crumbing
crumbles14329683crumbles
crumbs12409233crumb__s
crumbums1642733crumbums
crummies1437643crummies
cubbish1635803cubbish
cubebs12508683cu_bebs
cubers105318343cu_bers
cubes95028163cu_b_es
cubic114313423cu_bi_c
cubical1338463cu_bical
cubing114213953cu_bing
cubism12348703cu_bism
cubisms13306883cu_bisms
cubist104214443cu_bist
cubists11359023cu_bists
cubit94122893cu_bi_t
cubital1137103cu_bital
cubiti10399083cu_biti
cubitus11346783cu_bitus
cuboids1236723cuboids
cubs85832383cu_b__s
cudbear1233333cudbear
cudbears1343473cudbears
cuddies113313263cuddies
cuestas957933cuestas
cuifs104814693cu__ifs
cullies94419963cullies
cullis84115993culli_s
cumarins1238643cumarins
cumber124016703cumb_er
cumbrous1446173cumbrous
cumin94616973cum_i_n
cummers133713473cummers
cummin1288783cummi_n
cumquat2044513cumquat
cumquats2142833cumquats
cumshaw1742303cumshaw
cumshaws1842223cumshaws
cumulus1135453cumulus
cupids11369193cu_pids
cupolas11277753cupolas
cuppas12458593cu_ppas
curaras93911943curaras
curbers115514373curbers
curbing123814023curbing
curbings13407313curbings
curbs94821653curb__s
curia74523763cu_ria_
curiae84518373cu_riae
curial84019153cu_rial
curies84934023cu_ries
curios83218333cu_rios
curries93723163curries
cuspids12427113cuspids
cuspis105010703cuspi_s
cuties84927363cu_ties
cutins83919983cu_tins
cutis77723753cu_ti_s
cutlas8313093cu_tlas
cutties93118843cutties
cymas126417883cym__as
cymbal15236913cymb_al
cymbals16236143cymbals
cymlins1436693cymlins
dubbins12358803dubbins
dulias71212743du_lias
dumas85420433dum__as
dumbing13319853dumbing
dumbos114111083dumb_os
dumbs105915753dumb__s
dummies123012133dummies
exurbias1743653exurbias
fumbles143514413fumbles
funkias1435383funkias
gambas115817513gamb_as
gambia115912243gambia_
gambirs12359083gambirs
gambits12399723gambits
gumboils1343893gumboils
gumbos114610873gumb_os
gummas114810513gum_mas
hubbies143211563hubbies
humbles143215803humbles
humbugs1534243humbugs
iambics13425643iambics
jubas144614223ju_b_as
jumbal1758463jumb_al
jumbals18106533jumbals
jumbles183013323jumbles
jumbos17379123jumb_os
kumiss1235923kum_iss
lambdas1246243lambdas
lambies113015113lambies
lamias85020613lam_ias
limbas105313203limb_as
lumas75622913lum__as
lumbar103610593lumb_ar
lumbars11289763lumbars
lumbers113815913lumbers
macumbas1653003macumb_as
mambas125716243mamb_as
mbiras1077153__mbiras
misbias1139083misbias
mumbles133014433mumbles
mummies103812843mummies
nubbins11268023nubbins
nubia7311233nu_bia_
numbat10312083numb_at
numbats1137673numbats
numbers113711243numbers
numbing12269033numbing
numbles113814273numbles
numbs94913093numb__s
nutrias739813nutrias
obias76116863__obias
outbids1098913outbids
pembinas1454133pembinas
phobias14228183phobias
pubis94616473pu_bi_s
pumas95121563pum__as
qubits173710353qu_bits
ramblas112710263ramblas
rhumbas14305163rhumb_as
rubbies114114113rubbies
rubies84420343ru_bies
rugbies10339353rugbies
rumba93612513rumb_a_
rumbles114018393rumbles
rummies113212793rummies
sambas104219263samb_as
scubas103710223scu_b_as
scumbag1443573scumb_ag
scumbags1543203scumbags
scumbles1447023scumbles
subas74724073su_b_as
submiss1138083submiss
submits1139743submits
summas104313163sum_mas
summits1137973summits
terbias9310743terbias
tibias839953_tibias
tubas75119573tu_b_as
tumbles113816023tumbles
tumbrils12255373tumbrils
tummies113012033tummies
turbits969233turbits
umbels104510593_umbels
umbers104215213_umbers
umbles103817493_umbles
umbos94613073_umb_os
umbra948513_umbra_
umbrae1038683_umbrae
umbral1038633_umbral
umiac938963_um_iac
umiacs1035663_um_iacs
umiak1137673_um_iak
umiaks1244953_um_iaks
umiaq1656823_um_iaq
umiaqs1733003_um_iaqs
urbia7311143_urbia_
yummies14359533yummies
zamias174212923zam_ias
zombies2037993zombies
zombis1936283zombi_s

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340272487.89016986.9
3Display Results2482480.0932666.7
 (SQL Overall)1786912488.14321944.1
 
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.