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

342 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
sialids83972(None) 
sialid7314941sialid_
bialies93618412bialies
bialis83617162biali_s
diacids1137862diacids
halids104016132_halids
ozalids1794062ozalids
saids65328852s_a_ids
saiyids11174892saiyids
salads75316962s_alads
salpids1038192s_alpids
sayids104310972s_ayids
scalds94813692scal_ds
sialic8313632siali_c
sialidan943822sialidan
sialidans1042972sialidans
sialoid8310962sialoid_
sials54227242sial__s
siganids1045302siganids
silds65520522si_l_ds
sillies73425082sillies
simlins9311842simlins
skalds11437832skal_ds
solids74116402s_olids
sparids103512122sparids
aaliis6312903_aaliis
acarids105312243acarids
acids87121003__acids
agamids11317013agamids
aiblins9311473aiblins
aids57846353__a_ids
aiolis6316843aioli_s
alcids94812293__alcids
alias55834603__alias
alifs86121263__alifs
amids85627513__amids
aramids102810513aramids
ascarids11438503ascarids
bailies94120203bailies
balds85524643_bal_ds
biali73419073biali__
bialys11387913bial_ys
bields94110003biel_ds
billies93923503billies
braids95015693bra_ids
caids85226423_ca_ids
califs114915893_califs
canids95118133_canids
chalcids1635893chalcids
cichlids1643663cichlids
cyanids13297933cyanids
dailies84219263dailies
diacid10310633diacid_
dialed84716453dialed_
dialers83614303dialers
dialing94318173dialing
dialings10329823dialings
dialist8517763dialist
dialists9411413dialists
dialogs938103dialogs
dials64925343dial__s
diamide1138473diamide
diamides1238823diamides
diamins10312213diamins
diapirs10347643diapirs
diapsids1244753diapsids
diaries83321953diaries
diazins1739183diazins
dillies84122163dillies
dioxids1655683dioxids
diploids1247843diploids
elapids1036503elapids
eyelids1135943eyelids
felids103111623_felids
fields104211043fiel_ds
fillies103420253fillies
fillips12298133fillips
finalis103313663finali_s
gadids95611823_gadids
gilds75417523gi_l_ds
gillies84120963gillies
girlies83013703girlies
goalies8316023goalies
halid94424983_halid_
halide103417993_halide
halides113416663_halides
haloids113012553_haloids
hyalins13229273hyalins
hyaloids1545993hyaloids
iliads7448673_i_liads
imids86015143_i_mids
invalids1244743invalids
iodids83711153_iodids
irids66417773_i_rids
isatins7310773isatins
islands837323islands
italics936993italics
kalifs134410983_kalifs
khalifs1754073khalifs
kidvids1643113kidvids
kilims1277903ki_lims
killies113318113killies
liards75212613lia_rds
lids56336453___lids
lilies63021413li_lies
lipids94310923li_pids
lipoids1038233lipoids
liquids1735823liquids
maids86327143_ma_ids
mealies92821933mealies
miladis1049823miladis
milds86422053mi_l_ds
mislies92922283mislies
naleds7469133_naleds
niacins938543niacins
nitrids8269633nitrids
oxalis1339223oxali_s
ozalid1696683ozalid_
pilis75825203pi_li_s
plaids94312443pla_ids
psyllids1443023psyllids
pyralids1445813pyralids
qaids156116313_qa_ids
raids65827513_ra_ids
ranids75118703_ranids
rapids94913893_rapids
rials55026673rial__s
rialtos736613rialtos
ribalds10236673ribal_ds
riflips1234163riflips
sabins85521983s_abins
sabirs85414633s_abirs
sadis64930853s_adi_s
sahibs1137083s_ahibs
said55742113s_a_id_
sailed74327763sailed_
sailers73822323sailers
sailing83927373sailing
sailings93513253sailings
sailors73213723sailors
sails55738103s_a_ils
saimins9312113saimins
sains55639973s_a_ins
saiyid10167413saiyid_
sakis95323673s_aki_s
salad65321833s_alad_
salals65120083s_alals
saleps85014903s_aleps
sales56055593s_al_es
salic73424713s_ali_c
salify12311373s_alify
salina64221123s_alina
salinas73116093s_alinas
saline65132703s_aline
salines74029413s_alines
saliva93110743s_aliva
salivas10309603s_alivas
sallies73227813sallies
salmis8514273s_almis
salols64017873s_alols
salons63823693s_alons
salpas85116923s_alpas
salpid9510883s_alpid_
salps74423243s_al_ps
sals46851673s_al__s
salsas65316133s_alsas
salties73725773s_alties
salts55431883s_al_ts
salves94221763s_alves
salvias10279933s_alvias
salvos94613383s_alvos
sands65228583s_a_nds
sanies63031953s_anies
sapid84720933s_apid_
sards64736183s_a_rds
sarins63932623s_arins
saris54544953s_ari_s
sarods74918573s_arods
sasins64923103s_asins
satins64930483s_atins
satis55633683s_ati_s
savins93923133s_avins
sayeds10469253s_ayeds
sayid95516723s_ayid_
sayyids14193833sayyids
scabies11613333scabies
scads85419963sca__ds
scalade10359263scalade
scalades11258803scalades
scalado10276473scalado
scalados11276083scalados
scalars93711903scalars
scald84818123scal_d_
scaldic1235943scaldic
scaled94822443scaled_
scalers93817263scalers
scales84529313scal_es
scalier94316913scalier
scaliest101714393scaliest
scaling103519373scaling
scalls84218203scal_ls
scalps104315233scal_ps
sciaenids1242453sciaenids
sciatics12117273sciatics
sciurids1143343sciurids
scolds95011233scol_ds
seabeds10417223seabeds
seabirds1164403seabirds
sealed74328363sealed_
sealers74323553sealers
sealift10312793sealift
sealifts1135473sealifts
sealing83528563sealing
seals54839693seal__s
seaside839693seaside
seasides938743seasides
shads95124483sha__ds
shairds11216263shairds
shaled105023953shaled_
shales94731253shal_es
shalier103116423shalier
shaliest111415053shaliest
shaloms1288983shaloms
shards104319173sha_rds
sharias102516003sharias
sharifs13279903sharifs
shasliks1544143shasliks
shavies134213203shavies
shields11538043shiel_ds
sial45938833sial___
sibling10814423sibling
siblings11108123siblings
sickies133717503sickies
sicklies14710013sicklies
sidled84215173sidled_
sidlers83414233sidlers
sidles74721153sidl_es
sidling9915423sidling
siganid947203siganid_
sigils73912363si_gils
siglos7311473sigl_os
sigmoids1244453sigmoids
silages82514443silages
silanes72517163silanes
sild55030583si_l_d_
silica8311243si_lica
silicas9310603si_licas
silkies113715693silkies
silks94620683si_l_ks
sillers73822103sillers
sillier74017593sillier
silliest84017103silliest
sillily10209783sillily
sills55135993si_l_ls
silos56029433si_l_os
silts55330823si_l_ts
silurids945103silurids
silvas92912183si_lvas
silvics1235563silvics
similes92915233similes
simlin8311733simli_n
sinless73014213sinless
sirloins836723sirloins
sisals63013573sisal__s
siskins1159583siskins
sissies73716603sissies
sixties14310973sixties
skald104210173skal_d_
skaldic1443553skaldic
skids104615323s__kids
slaloms9106543slaloms
sleds64418853s__leds
slid55828983s__lid_
slide64725413s__lide
slides73922183s__lides
slims75423653s__lims
slips76023723s__lips
slits56128853s__lits
sloids73712693s_loids
smalls84514123smal_ls
smaltos9408193smaltos
smalts85214893smal_ts
snails64816653sna_ils
solands84412343solands
solid65025083s_olid_
solidi73813153s_olidi
solidus8338113s_olidus
spahis11310383spahi_s
spails84817823spa_ils
spaits85017473spa_its
spales84728103spal_es
spalls84217343spal_ls
sparid94016933sparid_
sparoids11218713sparoids
spavies123012943spavies
spavins12419323spavins
splits85416413s_plits
squalid1737053squalid_
squids16409803s_quids
stadias8411113stadias
staid66722083sta_id_
staigs75414813sta_igs
stains64923653sta_ins
stairs65416333sta_irs
stalags838643stalags
staled74728103staled_
stales65538293stal_es
staling83925423staling
stalks104614553stal_ks
stalls64019933stal_ls
stands75118053sta_nds
stasis63116873stasi_s
statics93314533statics
statins73719773statins
stolid74213183stolid_
stupids1035273stupids
sulfids1137293sulfids
sullies74122233sullies
susliks1136443susliks
swails94913123swa_ils
swains94513953swa_ins
swales93920763swal_es
swamies123712063swamies
swamis114212293swami_s
swards105415133swa_rds
sylis84316023s_yli_s
tineids8337873tineids
triacids1146723triacids
valid94618393_valid_
vialed105112593vialed_
vialing113614163vialing
vials85822383vial__s
viands1047813via_nds
violins10311453violins
viroids1137923viroids
walies95324523_walies
wealds10459103weal_ds
wields10469623wiel_ds
wilds94818203wi_l_ds
willies103920153willies
woalds10427583woal_ds
yields10466843yiel_ds

Search took 8 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.1401276364.3
2DLD Change Limit1340273427.40618097.1
3Display Results3423420.1103109.1
 (SQL Overall)1786913427.65623340.0
 
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.