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

186 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
sialoid831096(None) 
sialid7314941sial_id
diploid11310292diploid
haloid104317762_haloid
hyaloid1439072hyaloid
lianoid837532lianoid
salpid9510882s_alpid
sepaloid1146762sepaloid
sialic8313632sial_ic
sialids839722sial_ids
sigloi737742sigloi_
sigmoid1146112sigmoid
siloed74615302si_loed
simioid1047992simioid
sirloin747592sirloin
sloid64619712s__loid
sparoid102311542sparoid
styloid1137552styloid
acaroid103512313acaroid
agatoid948623agatoid
alcid85817973__alcid
algid75415583__algid
algoid83011473__algoid
alkaloid1345293alkaloid
aloin55227423__aloin
aloud65018073__aloud
amyloid1348543amyloid
arilloid946623arilloid
aroid65428343__aroid
avoid95516683__avoid
biali73419073bial_i_
bialis83617163bial_is
chalcid1537883chalcid
cheloid13310833cheloid
cirsoid1038123cirsoid
cissoid1037343cissoid
colloid10312883colloid
cycloid1539283cycloid
diacid10310633dia_cid
dialed84716453dial_ed
dialled9510133dialled
dialog837973dialo_g
dialoged1146693dialoged
dialogic1247453dialogic
dialogs938103dialogs
diamond1186113diamond
diapsid1146703diapsid
diploic1247763diploic
diploids1247843diploids
diploidy1544733diploidy
discoid11311243discoid
euploid1038963euploid
fibroid1337243fibroid
gadoid9310463_gadoid
ganoid8314443_ganoid
gavialoid1451913gavialoid
halid94424983_hal_id
haloed104717603_haloed
haloids113012553_haloids
haploid1339833haploid
hilloed113211293hilloed
histoid1139823histoid
hyaloids1545993hyaloids
inlaid7310143_inlaid
keloid11812623_keloid
liguloid1044133liguloid
limuloid1143983limuloid
lipoid9411043li_poid
lithoid1148773lithoid
loid55531493___loid
meloid9616003_meloid
milord999573mi_lord
mislaid1039303mislaid
myeloid13108123myeloid
oceloid1037973oceloid
oidioid946053oidioid
ozalid1696683ozal_id
pallid93915283_pallid
petaloid1148753petaloid
placoid1239773placoid
said55742113s_a__id
sailed74327763sail_ed
sailor63113753sailo_r
sailors73213723sailors
saiyid10167413s_aiyid
salad65321833s_al_ad
salic73424713s_al_ic
sallied83316953s_allied
salmi7815863s_almi_
salmis8514273s_almis
salmonid1147633s_almonid
salol55222143s_alo_l
salols64017873s_alols
salon55228553s_alo_n
salons63823693s_alons
saloon64418023s_aloon
saloop84212583s_aloop
salpids1038193s_alpids
salted74121203s_alted
saltie63422433s_altie
salved103916423s_alved
salvia93310753s_alvia
salvoed11307063s_alvoed
sapid84720933s_a_pid
sarcoid10310453sarcoid
sarod65325873s_aro_d
sayid95516723s_a_yid
sayyid13185353s_ayyid
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scaled94822443scal_ed
scalped124411993scalped
scaphoid1646053scaphoid
sciaenid1153573sciaenid
sciaenoid1242953sciaenoid
scincoid1344753scincoid
sciuroid1144403sciuroid
seafood1146153seafood
sealed74328363seal_ed
sesamoid1144063sesamoid
shaled105023953shal_ed
shalom11810923shalo_m
shaloms1288983shaloms
shamois123210423shamois
shipload1464343shipload
shitload1294003shitload
sial45938833sial___
sialidan943823sial_idan
sials54227243sial__s
sidled84215173sidl_ed
siganid947203siganid
siglos7311473siglo_s
sigmoids1244453sigmoids
sild55030583si_l__d
silked114314813si_lked
silkie103313403si_lkie
silo46037913si_lo__
siloing83215503si_loing
silos56029433si_lo_s
silted74020013si_lted
silurid837013silurid
siluroid945053siluroid
simlin8311733siml_in
sinusoid944383sinusoid
sirloins836723sirloins
sistroid947263sistroid
sixfold1842723sixfold
skald104210173skal__d
skaldic1443553skaldic
slalom888173slalo_m
slalomed1134283slalomed
slaloms9106543slaloms
sleazoid1843203sleazoid
slid55828983s__l_id
sloids73712693s__loids
slojd13378843s__lojd
sloyd9409683s__loyd
smalti84111193smalti_
solid65025083s_ol_id
soloed74515743s_oloed
spalled103113133spalled
sparid94016933spa_rid
sparoids11218713sparoids
spiroid10219823spiroid
sporoid102310733sporoid
squalid1737053squal_id
staid66722083sta__id
staled74728103stal_ed
stalked123811173stalked
stalled83515693stalled
steroid81314863steroid
stolid74213183stol_id
sulfid1039063s_ulfid
tabloid1048263tabloid
thalloid1246283thalloid
triploid1147363triploid
valgoid1255213_valgoid
valid94618393_val_id
vialed105112593vial_ed
vialled1156843vialled
viroid10411523vi_roid
viscoid1337023viscoid
xiphoid2045923xiphoid
xyloid1738193_xyloid
zincoid1946663zincoid

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.406440125.6
2DLD Change Limit1340271866.89019452.4
3Display Results1861860.0632952.4
 (SQL Overall)1786911867.35924282.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.