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 “sidh” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
sidh8622299(None) 
side55444491side
sidhe95315101sidhe
sigh85625891sigh
sinh76238041sinh
sith75435151sith
aid49269082aid_
aide56045002aide
aids57846362aids
aside65122082aside
bid67751812bid_
bide76041502bide
bidi78226592bidi
bids75838452bids
did56850522did_
dido66528202dido
didy99121512didy
dish86328332dish
edh76921562_edh
eide55832242eide
fid76847692fid_
fido87726402fido
fids87034742fids
fish106926272fish
gid57047272gid_
gids65933742gids
hid76248382hid_
hide85134642hide
high116619922high
ich86227742_ich
id38941842_id_
ids47535472_ids
kid86540622kid_
kids96029642kids
kith115826362kith
lich96230842lich
lid47453522lid_
lido56028162lido
lids56336462lids
mid67354472mid_
midi75628482midi
mids76541792mids
nide55535792nide
nidi56524402nidi
nigh85220662nigh
pish96127912pish
pith95432692pith
rich97025542rich
rid46754632rid_
ride55945132ride
rids56539552rids
sad47459202sad_
sade55544472sade
sadhe94815132sadhe
sadhu9459962sadhu
sadi55834642sadi
said55742112said_
saids65328852saids
saith85826552saith
sash77235302sash
sh56828522s__h
shah105627782shah
shh97121072s_hh
si29149572si__
sial45938832sial
sib56850312si_b
sibb85921422sibb
sibs65933542sibs
sic55847872si_c
sice65545592sice
sick106435572sick
sics65234092sics
sided74825952sided
sides65838362sides
sidle65124032sidle
sift710740662sift
sighs95416742sighs
sight94629292sight
sign55523052sign
sika86021322sika
sike87138782sike
sild55030582sild
silds65520522silds
silk85529322silk
sill45545152sill
silo46037912silo
silt46558192silt
sim56553142si_m
sima64730782sima
simp85228772simp
sims65737172sims
sin36265892si_n
sine46560622sine
sing57544172sing
sinhs86719602sinhs
sink86640142sink
sins46755272sins
sip57656012si_p
sipe67341042sipe
sips65740102sips
sir35746672si_r
sire46150412sire
sirs44338332sirs
sis37360542si_s
sit35877752si_t
site47052412site
sits45050202sits
six105339742si_x
sixth155512232sixth
size135630962size
sizy164816392sizy
skid95720932skid_
skids104615332skids
slid55828982slid_
slide64725412slide
smith107818052smith
snide64318722snide
sod46053702sod_
soda56329382soda
sods54940212sods
soph97024202soph
soth75932522soth
stich104117922stich
such96424812such
sudd64719772sudd
suds56135292suds
sugh86423442sugh
swish115114822swish
swith115917402swith
syph125413272syph
tide55237382tide
tidy86822422tidy
vid77241812vid_
vide85432762vide
vids85627542vids
wich125724742wich
wide85235412wide
width12310962width
wish107228732wish
with105730472with
yid76640832yid_
yids85224962yids
yodh119916102yodh

Search took 3 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 Filter178691298720.596299817.1
2DLD Change Limit298721431.62318405.4
3Display Results1431430.0304766.7
 (SQL Overall)1786911432.24979453.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.