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

146 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
labrums117585(None) 
labarums1254501labarums
labrum1057421labrum_
larums83610531la_rums
alarums9408922alarums
albums10198272alb_ums
arums75517832_a_rums
aurums849382_aurums
labarum1166012labarum_
labium10410242labium_
labours9349892labours
labrets939362labrets
laburnums1382212laburnums
larrups934732larrups
larum74317972la_rum_
pablums1345122pablums
sacrums11388042sacrums
abohms1335003_abohms
abris75722603_abr_is
abrupt1039943_abrupt
abuts75417073_ab_uts
abysms13565653_abysms
alarms85913053alar_ms
alarum85411983alarum_
album92312653alb_um_
alburnums1372013alburnums
algums9208043_algums
alliums957973alliums
alums75720603_a_lums
antrums969173antrums
arms66137493_a_r_ms
arum66129033_a_rum_
asarums9467613asarums
atriums939043_atriums
aurum7614963_aurum_
babuls105413643bab_uls
babus95620333bab_u_s
barbuts11439843barbuts
bariums1139143bariums
barms96128463ba_r_ms
brims94721623__brims
brume95817983__brume
brumes106417073__brumes
bruts75922953__bruts
bums85934593__b_ums
cambiums1644933cambiums
caroms105619573ca_roms
carroms11512403carroms
cuprums1334453cuprums
datums936353da_tums
drums85415873__drums
durums948153_durums
earbuds1044633earbuds
eardrums11524483eardrums
embrues1136473embrues
erbiums1135463erbiums
estrums9208603estrums
fabrics1436093fabrics
fanums1137263fa_nums
farms106324953fa_r_ms
ferrums1265983ferrums
forums114611843_forums
gaums86217073ga__ums
glabrous1145533glabrous
habus106317143hab_u_s
harems115513823ha_rems
harms106829013ha_r_ms
imbrues1135503imbrues
jabirus1694573jabiru_s
jorums15408093_jorums
kaliums1336603kaliums
labdanums1452153labdanums
labels84515683lab_els
labials9299873labials
laborers10208383laborers
labors84016413lab_ors
labour84210933labou_r
labra75415463labr__a
labret8320223labr_et
labroid1038823labroid
labroids1155843labroids
labrusca1241913labrusca
labs67145123lab___s
laburnum1262913laburnum_
lactams1136953lactams
ladanums1143603ladanums
ladrons83813193ladrons
lairds74711613lair_ds
lairs55425873lair__s
lams66552263la___ms
langues81211913langues
langurs889103langurs
lapfuls1234503lapfuls
lapsus8437273lapsu_s
lards65331863la_r_ds
larees65323113la_rees
lares54852633la_r_es
larges74824233la_rges
largos74815063la_rgos
laris54737463la_r_is
larks95227813la_r_ks
larrup835713larru_p
lars46956573la_r__s
larvas9310233la_rvas
latrias71913213latrias
lauds65618483la__uds
lauras63414333laur_as
laurels746663laurels
layouts1046483layouts
layups1133993la_yups
libras83711703libr_as
linums838283l_inums
locums10478303l_ocums
lums65734243l___ums
lustrums1044663lustrums
lyceums1442403lyceums
magnums1234683magnums
marrams11310123marrams
nairus639143nairu_s
natriums1046293natriums
oakums1264153oa_kums
pablum1237503pablum_
pabulums1443003pabulums
plastrums1344513plastrums
quorums1843893quorums
radiums10299313radiums
rums64833473___rums
sabras85116363sabr_as
sabres85520863sabr_es
sacrum103910143sacrum_
scrums104614253_scrums
sebums10369813seb_ums
serums83916303_serums
strums84716453_strums
subgums1235893subgums
tabours94110093tabours
tabuns8489223tab_uns
tabus74820923tab_u_s
talcums1135513talcums
tantrums1045113tantrums
thrums11429123_thrums
vacuums1443403vacuums
varus85921183va_ru_s
walrus956433walru_s
wampums16314213wampums
warms107726853wa_r_ms

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.453394461.4
2DLD Change Limit1340271466.40620922.1
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.90525878.5
 
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.