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

191 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
labrum105742(None) 
labarum1166011labarum
labium10410241labium
labrums1175851labrums
larum74317971la_rum
alarum85411982alarum
album92312652alb_um
arum66129032_a_rum
aurum7614962_aurum
labarums1254502labarums
labour84210932labour
labra75415462labr_a
labret8320222labret
laburnum1262912laburnum
larrup835712larrup
larums83610532la_rums
pablum1237502pablum
sacrum103910142sacrum
abeam9316533_abeam
abohm1247973_abohm
about75229083_about
abri65522213_abr_i
abris75722603_abris
abrupt1039943_abrupt
abut66834953_ab_ut
abysm12598143_abysm
alarm76621423alar_m
alarums9408923alarums
albums10198273alb_ums
alburnum12112863alburnum
algum82711763_algum
allium8311243allium
alum65227613_a_lum
antrum8611313antrum
arm58449623_a_r_m
arums75517833_a_rums
asarum84610913asarum
atrium8411823_atrium
aurums849383_aurums
babu85829233bab_u_
babul96317713bab_ul
babus95620333bab_us
barbut104617003barbut
barium10313513barium
barm86739603ba_r_m
brim85629373__brim
brume95817983__brume
brut66537963__brut
brux136315273__brux
bum75342693__b_um
caecum1238183caecum
cambium1537323cambium
carom95025563ca_rom
carrom10513403carrom
cuprum1236743cuprum
dadgum1134583dadgum
datum8310633da_tum
drum76521593__drum
durum8513203_durum
earbud936283earbud
eardrum10135423eardrum
elytrum1243563elytrum
embrue1036533embrue
erbium1038083erbium
estrum81810513estrum
fabric1337833fabric
fanum10313443fa_num
farm95934533fa_r_m
ferrum1147453ferrum
forum108318763_forum
gaum75726423ga__um
glabrous1145533glabrous
grum75625083__grum
habu97325483hab_u_
habus106317143hab_us
harem104924453ha_rem
harm95637793ha_r_m
imbrue1035153imbrue
iterum837903iterum
jabiru15125513jabiru_
jabirus1694573jabirus
jorum145513743_jorum
kalium1239473kalium
laari54415713laar_i
lab58864783lab___
labara83712893labara
labdanum1342923labdanum
label75019383lab_el
labellum1274273labellum
labels84515683labels
labia75219013lab_ia
labial84714343labial
labile8315223labile
labor75117313lab_or
labored102810243labored
laborer9249503laborer
labors84016413labors
labours9349893labours
labrets939363labrets
labroid1038823labroid
labrusca1241913labrusca
labs67145123lab__s
laburnums1382213laburnums
lactam10310943lactam
ladanum1045183ladanum
ladron73413323ladron
lair45934153lair__
laird65417793lair_d
lairds74711613lairds
laired75216813laired
lairs55425873lair_s
lam57666713la___m
langue71012173langue
langur7109303langur
lapful1156483lapful
lapsus8437273lapsus
lar37967533la_r__
larch105919793la_rch
lard56742003la_r_d
lards65331863la_rds
lardy96119273la_rdy
laree56036293la_ree
lares54852633la_res
large65325463la_rge
largo65319783la_rgo
lari45839153la_r_i
laris54737463la_ris
lark85733863la_r_k
larks95227813la_rks
larky125218873la_rky
larrups934733larrups
lars46956573la_r_s
larva8312483la_rva
latria62313593latria
latu47934183la_tu_
laud56527723la__ud
laura54116203laur_a
laurae64011663laurae
lauras63414333lauras
laurel649033laurel
lawful1235493lawful
layout9513703layout
layup1037723la_yup
libra74712423libr_a
librae84310173librae
libras83711703libras
libri74610113libr_i
linum7313823l_inum
locum94812173l_ocum
lubric1097983lubric
lum55542933l___um
lustrum945853lustrum
luteum837783luteum
lyceum1343953lyceum
magnum1136733magnum
marram10313883marram
nairu5413813nairu_
nairus639143nairus
natrium948983natrium
oakum1177313oa_kum
pablums1345123pablums
pabulum1344473pabulum
plastrum1245713plastrum
quorum1736023quorum
radium93513293radium
rum56644643___rum
sabra75317853sabr_a
sabras85116363sabras
sabre74821503sabr_e
sabred95916533sabred
sabres85520863sabres
sacrums11388043sacrums
sagum8512873sa_gum
scrum95418193_scrum
sebum93814553seb_um
serum75223473_serum
strum75619453_strum
subgum1136133subgum
tabour84011323tabour
tabu66328493tab_u_
tabun75914373tab_un
tabus74820923tab_us
talcum1036953talcum
tantrum946683tantrum
thrum104713633_thrum
vacuum1334833vacuum
vagrom1235943vagrom
varus85921183va_rus
walrus956433walrus
wampum15406053wampum
warm95935673wa_r_m

Search took 10 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161918.86012721.9
3Display Results1911910.0464152.2
 (SQL Overall)1786911919.27919257.6
 
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.