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

192 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
sigloi73774(None) 
siglos7311471siglos
diglot83014332diglot
giglot84013132giglot
igloo6410492_igloo
sialoid8310962sialoid
sigla64515202sigl_a
siglum936562siglum
sigmoid1146112sigmoid
signor73510352signor
signori8347892signori
silo46037912si_lo_
silos56029432si_los
sirloin747592sirloin
tiglon737922tiglon
aglow94711973_aglow
aiglet74224193aiglet
aioli5318313aiol_i
airglow1143673airglow
anglo65215373anglo_
anglos74413913anglos
biali73419073bial_i
bigly114814753bigl_y
bigos85020013big_os
bigot84828323big_ot
billon83713833billon
billow114111223billow
dialog837973dialog
diglots9299503diglots
diploe9810153diploe
diploic1247763diploic
diploid11310293diploid
fillo84319783fillo_
fillos94415083fillos
filmi105914003fi_lmi
filo76034283fi_lo_
filos86125383fi_los
giglet83920273giglet
giglots9367863giglots
gigolo836533gigolo
gigolos934693gigolos
gigot74023073gig_ot
glob76623393__glob
glom75424383__glom
glop76724633__glop
glow85222523__glow
hili75626633hi_l_i
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
igloos738033_igloos
iglu510814783_igl_u
iglus6609933_iglus
isolog737403isolog
kilo86028673ki_lo_
kilos95021473ki_los
ligroin848043ligroin
liguloid1044133liguloid
lilo46731563li_lo_
lilos55821873li_los
logoi69715943log_oi
mignon937953mignon
milo65536103mi_lo_
milos75428013mi_los
nielli636303nielli
nilgai734883nilgai
pigeon949413pigeon
piglet93420923piglet
pignoli1045443pignoli
pilei74021783pi_lei
pili66130353pi_l_i
pillow113110573pillow
pilot77435063pi_lot
reglow10339403reglow
rigor62714053rig_or
sago56332673sag_o_
sagos66123873sag_os
sailor63113753sailor
sallow94315753sallow
salmi7815863s_almi
salol55222143s_alol
salon55228553s_alon
sawlog1035793sawlog
segni63712483seg_ni
segno64814743segno_
segnos73610443segnos
sego56525183seg_o_
segos64919483seg_os
shalom11810923shalom
sholom11910113sholom
sial45938833sial__
sialic8313633sialic
sialid7314943sialid
sials54227243sial_s
sicko115315393sicko_
sickos125112033sickos
sidle65124033sidl_e
sidled84215173sidled
sidler74716963sidler
sidles74721153sidles
siganid947203siganid
sigh85625893sig__h
sighed113712053sighed
sigher103813703sigher
sighs95416743sig_hs
sight94629293sig_ht
sights103818013sights
sigil63515503sig_il
sigils73912363sigils
sigma84513833sig_ma
sigmas94111363sigmas
sigmoids1244453sigmoids
sign55523053sig__n
signa66114703sig_na
signal73711483signal
signed83413753signed
signee73617233signee
signer74015633signer
signet73621153signet
signior835043signior
signiori943353signiori
signora8348503signora
signore8329093signore
signors83410913signors
signory11427523signory
signs65516323sig_ns
sild55030583si_l_d
silds65520523si_lds
sileni63312143sileni
silex123417413si_lex
silk85529323si_l_k
silkie103313403si_lkie
silks94620683si_lks
silky125315823si_lky
sill45545153si_l_l
siller64026063siller
sills55135993si_lls
silly84527623si_lly
siloed74615303si_loed
siloing83215503si_loing
silt46558193si_l_t
silts55330823si_lts
silty84721633si_lty
silva82714023si_lva
simioid1047993simioid
simlin8311733simlin
simoom1037503simoom
simoon858063simoon
single74520603singl_e
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singl_y
siphon1138463siphon
sirloins836723sirloins
sitcom1036903sitcom
sixmo1448303sixmo_
sixmos1534813sixmos
slalom888173slalom
slob66029423s__lob
sloe45534953s__loe
slog56728273s__log
sloid64619713s__loid
slop66533873s__lop
slot46049833s__lot
slow77729493s__low
smalti84111193smalti
sniglet83612413sniglet
soldi65717203s_oldi
solei55624343s_olei
soli46637013s_ol_i
solo45538943s_olo_
solon55026133s_olon
solos54830793s_olos
spigot9312603spig_ot
stelai63912563stelai
stolon64112073stolon
styli83911173styl_i
styloid1137553styloid
sublot82315523sublot
sulci7615053s_ulci
sunglow1143943sunglow
syli74318983s_yl_i
teloi54217383_teloi
tholoi9339233tholoi
tiglons837343tiglons
tigon63914443tig_on
vigor92612423vig_or
villi86517853vi_lli
wigeon1037223wigeon
wiglet105519153wiglet
willow12369693willow

Search took 7 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.406440125.6
2DLD Change Limit1127161925.65619928.6
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.12529174.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.