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

196 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
jumbals1810653(None) 
jumbal1758461jumbal_
bubals103513842bu_bals
cymbals16236142cymbals
gimbals12257822gimbals
gumball1266832gumball
gumballs1345312gumballs
jubas144614222ju_ba_s
jubbahs2143622jubbahs
jumble174012652jumb_le
jumbles183013322jumbles
jumbos17379122jumb_os
lumbars11289762lumbars
numbats1137672numbats
rumbas102512012rumba_s
sambals115213482sambals
timbals11239532timbals
tymbals14265722tymbals
umbels104510592_umbels
atabals938413atabals
bals66354043___bals
bubal94218213bu_bal_
bubale104014623bu_bale
bubales113513343bu_bales
bubalis11359903bu_balis
bubbas94110703bubba_s
bulbels11398013bulbels
bulbils11338333bulbils
bulbuls11346783bulbuls
bumble124216893bumb_le
bumbles134016843bumbles
bumboats1445183bumboats
bummalo1353793bummalo
bummalos1442873bummalos
burials93612083burials
busbars1138153busbars
buttals938503buttals
cabals104020153_cabals
cembali13156043cembali
cembalo13145533cembalo
cembalos14135163cembalos
combats13311683combats
cumbers134515413cumbers
cumbias13338963cumbias
curtals93111623curtals
cymbal15236913cymbal_
duals65620083du__als
dumas85420433dum_a_s
dumbly14399603dumb_ly
dumbos114111083dumb_os
dumbs105915753dumb__s
durbars1077973durbars
embalm1236653_embalm
embalms1335333_embalms
embars103812883_embars
embays131408333_embays
fumble133214263fumb_le
fumbles143514413fumbles
fungals11276783fungals
gambas115817513gamba_s
gambols1238593gambols
gimbal11228813gimbal_
gimmals12225823gimmals
gumboils1343893gumboils
gumbos114610873gumb_os
gummas114810513gumma_s
hamals114816833ham_als
hammals14409233hammals
herbals122710613herbals
humans112312433hum_ans
humble133615053humb_le
humbles143215803humbles
humbly164010523humb_ly
humbugs1534243humbugs
humerals1347183humerals
hymnals1543533hymnals
imbalm1246323_imbalm
imbalms1334553_imbalms
jacals1539873j_acals
jackals2036893jackals
jambes175914053jamb_es
jambs166014623jamb__s
jebels15418913j_ebels
jimjams1742073jimjams
jingals1588073jingals
jouals1338933j_ouals
journals1574353journals
juba134916983ju_ba__
jubbah2034353jubba_h
jubes145420743ju_b_es
jubhahs2242353jubhahs
jubile152910263ju_bile
jubiles16289373ju_biles
judas134911883ju_da_s
jugal135612403ju_gal_
jugfuls1843063jugfuls
jumbled19379963jumbled
jumbler183910273jumbler
jumblers19358323jumblers
jumbo164311073jumb__o
jumbuck2443273jumbuck
jumbucks2542953jumbucks
jumpable2143953jumpable
jumpers18399843jumpers
jumpily2174983jumpily
jumps165116493jum__ps
juntas134210503junta_s
jural125120483ju_ral_
jurats134213203ju_rats
jurels133710583ju_rels
juvenals1842773juvenals
kummels15234793kummels
limbas105313203limba_s
lumas75622913lum_a_s
lumbago1243833lumbago
lumbagos1343073lumbagos
lumbar103610593lumba_r
lumbers113815913lumbers
mambas125716243mamba_s
mammals10389273mammals
meals75933383__meals
mimbars1397383mimbars
mughals1355763mughals
mumble123614343mumb_le
mumbles133014433mumbles
mumbly15319463mumb_ly
murals84016763mu_rals
mutuals937133mutuals
nuchals12216943nuchals
numbat10312083numba_t
numbers113711243numbers
numbles113814273numbles
numbly134410663numb_ly
numbs94913093numb__s
numerals1047343numerals
outbawls1336053outbawls
pibals103813083_pibals
pumas95121563pum_a_s
pummels13236543pummels
quezals2544253quezals
ramblas112710263ramblas
rhumbas14305163rhumba_s
rubels84112993ru_bels
rumba93612513rumba__
rumbaed12287493rumbaed
rumble103718813rumb_le
rumbles114018393rumbles
rumbly134412163rumb_ly
sabals84618863_sabals
sambal105215183sambal_
sambars115113843sambars
sambas104219263samba_s
scumbags1543203scumbags
subahs114512383su_bahs
subas74724073su_ba_s
subbass1138033subbass
sumacs105512103sum_acs
summas104313163summa_s
symbols1435523symbols
tamals84116633tam_als
tambacs13219363tambacs
tambaks15218153tambaks
tambala1138023tambala
tambalas1237033tambalas
timbal102510753timbal_
timbale11248803timbale
timbales12227843timbales
tombacs13248443tombacs
tombaks15246863tombaks
tombal102311023tombal_
tribals9610753tribals
tubal75517203tu_bal_
tubas75119583tu_ba_s
tumble103215643tumb_le
tumbles113816023tumbles
tumbrels12285733tumbrels
tumbrils12255373tumbrils
turbans939563turbans
tymbal13236823tymbal_
umbel93612843_umbel_
umbers104215213_umbers
umbles103817493_umbles
umbos94613073_umb_os
umbral1038633_umbral_
umbras1038643_umbras
umiacs1035663_umiacs
umiaks1244953_umiaks
umiaqs1733003_umiaqs
unbale83616403_unbale
unbales92914863_unbales
unbans81912623_unbans
unbars82113033_unbars
urials64415193_urials
usuals637793_usuals
verbals121910743verbals
wombats1435893wombats

Search took 7 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 Limit1340271966.22021547.7
3Display Results1961960.0633111.1
 (SQL Overall)1786911966.68926714.2
 
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.