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

215 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
abloom103978(None) 
bloom95918971_bloom
abohm1247972ab_ohm
aboon74918702ab_oon
aloof83521572a_loof
blood85319522_blood
blooms104613172_blooms
bloomy134510112_bloomy
bloop96116152_bloop
boom87435672_b_oom
broom95022212_broom
gloom87116522_gloom
loom67035052__loom
rebloom1145662rebloom
abalone938903abalone
abator84512713abator
abbot9318453ab_bot
abbots1039283abbots
abeam9316533ab_eam
abhor10411063ab_hor
abhors11410623abhors
ablate82219213ablate
ablator939843ablator
ablaut8313263ablaut
ablaze17239833ablaze
able66340533abl__e
abled86926833abl_ed
ableism1136823ableism
abler75624313abl_er
ables75935543abl_es
ablest84721833ablest
ablins8316193ablins
ablush1147223ablush
ably99725133abl__y
abmho1236793abmho_
abmhos1334973abmhos
abo59045963ab__o_
abode85518813ab_ode
abohms1335003ab_ohms
aboil72217543ab_oil
abolla8410193abolla
aboma91114603ab_oma
abort76133583ab_ort
abos67734413ab__os
about75229083ab_out
above105414323ab_ove
abroad9310943abroad
absorb1038013absorb
abvolt11169833abvolt
abysm12598143ab_ysm
achoo10315083achoo_
afloat9315153afloat
afoot8420113a_foot
agleam9158623agleam
aglow94711973agl_ow
alamo7418143a_lamo
alarm76621423a_larm
album92312653a_lbum
aldol61212333a_ldol
algor6513053a_lgor
algum82711763a_lgum
allium8311243allium
allod64418383a_llod
allods73615083allods
allonym1244733allonym
allot54933873a_llot
allots64019173allots
allow85420663a_llow
allows94517683allows
alloy85519973a_lloy
alloys94014563alloys
aloe45540193a_l_oe
aloes54933673a_loes
aloft8423433a_loft
aloha8513613a_loha
aloin55227423a_loin
alone55732963a_lone
along65419493a_long
aloud65018073a_loud
alow75328593a_l_ow
also46423443a_lso_
alto47831263a_lto_
altos55822953a_ltos
alum65227613a_l_um
aplomb1236203aplomb
apolog938903apolog
aslope839013aslope
aslosh966233aslosh
aswoon947013aswoon
atom67824523a__tom
axiom143913593a_xiom
azlon144312873azl_on
azlons154110423azlons
baboo94319503baboo_
babool103012153babool
baboon103613913baboon
baboos103517013baboos
balboa10389963balboa
ballon84117493ballon
balloon93711433balloon
ballot84624093ballot
ballroom1245023ballroom
balm85534203bal__m
balsam105612233balsam
barroom1139373barroom
bazoo163815673bazoo_
bazooms20285383bazooms
bazoos173212623bazoos
beblood12106083beblood
begloom1255243begloom
besom95716973_besom
bhoot104322103_bhoot
blam86131703_bl_am
bloat75229923_bloat
blob86027093_bl_ob
blobs95620033_blobs
bloc85023273_bl_oc
block134917843_block
blocs95219653_blocs
blog75723823_bl_og
blogs85319233_blogs
bloke114316633_bloke
blond85618373_blond
bloods94614843_bloods
bloody124710173_bloody
blooey115110793_blooey
blooie83913193_blooie
bloomed12439433_bloomed
bloomer11419813_bloomer
bloops106611343_bloops
blossom11114963_blossom
blot65842323_bl_ot
blots75626173_blots
blow95827193_bl_ow
blown105716673_blown
blows105423833_blows
blowy134315323_blowy
bolo65535953_bolo_
bolos75531373_bolos
boo58163663_b_oo_
boob85932583_b_oob
book106836333_b_ook
booms95427123_b_ooms
boomy125421823_b_oomy
boon67142173_b_oon
boor66130683_b_oor
boos67955033_b_oos
boot67759373_b_oot
bosom95516923_bosom
bromo95217203_bromo
broo65129823_broo_
brood84620243_brood
brook114717763_brook
brooms104915873_brooms
broomy13449953_broomy
broos75126413_broos
buxom1647153_buxom
celom9515693cel_om
cloot76127053_cloot
dayroom1345233dayroom
doom76430073__doom
earldom1044583earldom
ebook114510803eb_ook
flood95215603_flood
floor84215233_floor
gaboon93211773gab_oon
galloon82910643galloon
galloot82814223galloot
galoot72719163galoot
gloam86015943_gloam
glom75424383_gl_om
glooms96211683_glooms
gloomy12528763_gloomy
groom85317983_groom
haboob1377883hab_oob
halloo95118973halloo_
halloos103716743halloos
handloom1444613handloom
igloo6410493igloo_
igloos738033igloos
jarldom1743123jarldom
jibboom2092493jibboom
kloof123812133_kloof
loam65630483__loam
loo38359823__loo_
loof78141053__loof
look87333473__look
looms75124643__looms
loon47344793__loon
loop67835013__loop
loos49051123__loos
loot46955823__loot
mailroom1244233mailroom
oblong935383oblong
outbloom1244003outbloom
oxblood1743603oxblood
pablum1237503pabl_um
phloem1335713phloem
reblooms1244283reblooms
relook104813743relook
room66235083__room
saloon64418023saloon
saloop84212583saloop
seldom939413seldom
sholom11910113sholom
simoom1037503simoom
sloop76118913_sloop
tabloid1048263tabloid
taboo73418093tab_oo_
taboos83815433tab_oos
taproom1147963taproom
toom66532933__toom
varoom11411413varoom
vroom105312473_vroom
zoom156722103__zoom

Search took 6 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 Limit1127162155.25021469.7
3Display Results2152150.0633412.7
 (SQL Overall)1786912155.68631426.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.