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

172 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
ozalid169668(None) 
ozalids1794061ozalids
halid94424982_halid
oxalic1537092oxalic
oxalis1339222oxalis
sialid7314942sialid
valid94618392_valid
aalii5316133_aalii
acarid95017073acarid
acid77533393__acid
agamid103710693agamid
aid49269083__a_id
alcid85817973__alcid
algid75415583__algid
alif76242143__alif
alit46155693__alit
amid77036353__amid
aramid93315613aramid
arid57642713__arid
avid88325963__avid
azalea1537003azalea
baalim1038473baalim
bald76432903_bal_d
baled85436443_baled
biali73419073biali_
bialis83617163bialis
braid85822263bra_id
caid77837533_ca_id
calif104929103_calif
calix145317353_calix
canid85526343_canid
chalcid1537883chalcid
coaled95022713coaled
cyanid123912043cyanid
diacid10310633diacid
dialed84716453dialed
elapid939543elapid
eyelid1038443eyelid
felid94717173_felid
foaled104515963foaled
gadid85517383_gadid
gelid74916983_gelid
goaled85014363goaled
goalie7413163goalie
gravid113710983gravid
haled95335823_haled
halide103417993_halide
halids104016133_halids
haloid104317763_haloid
healed105121443healed
hyalin122210043hyalin
hyaloid1439073hyaloid
inlaid7310143inlaid
invalid1146393invalid
italic839903italic
kalif125021363_kalif
khalif1657833khalif
laid56439143_la_id
lid47453523___lid
maid75537663_ma_id
malic94525663_malic
mealie82519813mealie
mohalim1446033mohalim
monacid121310243monacid
naled65525053_naled
nonacid101210843nonacid
nonvalid1245603nonvalid
oared65030653o_ared
oasis56422553o_asis
obeli73711933obeli_
obelia8329453obelia
oboli73712873oboli_
oceloid1037973oceloid
oculi72010793oculi_
odalisk1265373odalisk
ogled75915963o_gled
oiled64429473o_iled
okapi1136613okapi_
okapis1235393okapis
okayed1434253okayed
old47033463o__l_d
olio46829673o__lio
oorali6311263oorali_
ooralis7312553ooralis
ootid61416703o_otid
opal66923523opal__
opaline9412483opaline
opals75718353opal_s
opioid9310083opioid
orad56031693ora__d
oral47638123oral__
oralism9513763oralism
oralist7619633oralist
orality101111683orality
orally93113593orally
orals55826483oral_s
orated74221503orated
orchid1289573orchid
otalgia844483otalgia
otalgic1045063otalgic
otalgy1035353otalgy
outbid91411863outbid
outdid81210923outdid
outlaid81110653outlaid
outled74020343outled
outlie62419533outlie
oval77119523oval__
ovality1377593ovality
ovally12278443ovally
ovals85413393oval_s
ovoid94811023o_void
ovoli8358283ovoli_
oxid12815483o__xid
oxlip1456883o_xlip
oxyacid2062773oxyacid
ozonic17308943ozonic
ozonide1754963ozonide
paid75737483_pa_id
paled85538723_paled
pallid93915283pallid
pavid115717003_pavid
pealed95322813pealed
placid114012543placid
plaid85118303pla_id
pyralid1347983pyralid
qaid146023843_qa_id
qualia1559563qualia
rabid84520783_rabid
raid55243073_ra_id
ranid66429333_ranid
rapid86422033_rapid
realia6314593realia
relaid75518443relaid
said55742113_sa_id
salad65321833_salad
salic73424713_salic
salpid9510883_salpid
sapid84720933_sapid
sayid95516723_sayid
scald84818123scal_d
scaled94822443scaled
sealed74328363sealed
shaled105023953shaled
sialic8313633sialic
sialids839723sialids
sialoid8310963sialoid
skald104210173skal_d
slid55828983__slid
solid65025083_solid
sozzled16265183sozzled
sparid94016933sparid
squalid1737053squalid
staid66722083sta_id
staled74728103staled
stolid74213183stolid
tabid84418263_tabid
tali46837163_tali_
totaled839693totaled
unlaid7311753unlaid
vapid115614283_vapid
vealed103916323vealed
vialed105112593vialed
vocalic1446943vocalic
waled94330993_waled
weald95615023weal_d
whaled134612033whaled
woald94813073woal_d
yald86920613_yal_d
zamia165115213_zamia
zayin174512043_zayin
zoaria1548383zoaria
zooid15312103_zooid

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.376475242.0
2DLD Change Limit1127161724.82623356.0
3Display Results1721720.0463739.1
 (SQL Overall)1786911725.24834049.4
 
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.