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
sidh8622298(None) 
side55444481side
sidhe95315101sidhe
sigh85625891sigh
sinh76238041sinh
sith75435151sith
aid49269072aid_
aide56044992aide
aids57846352aids
aside65122082aside
bid67751792bid_
bide76041482bide
bidi78226572bidi
bids75838432bids
did56850512did_
dido66528192dido
didy99121502didy
dish86328332dish
edh76921562_edh
eide55832232eide
fid76847682fid_
fido87726392fido
fids87034732fids
fish106926272fish
gid57047262gid_
gids65933732gids
hid76248362hid_
hide85134622hide
high116619912high
ich86227742_ich
id38941832_id_
ids47535462_ids
kid86540612kid_
kids96029632kids
kith115826352kith
lich96230842lich
lid47453512lid_
lido56028152lido
lids56336452lids
mid67354462mid_
midi75628472midi
mids76541782mids
nide55535782nide
nidi56524392nidi
nigh85220662nigh
pish96127912pish
pith95432692pith
rich97025542rich
rid46754622rid_
ride55945122ride
rids56539542rids
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
sim56553132si_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
skid95720912skid_
skids104615322skids
slid55828982slid_
slide64725412slide
smith107818052smith
snide64318722snide
sod46053702sod_
soda56329382soda
sods54940212sods
soph97024202soph
soth75932512soth
stich104117922stich
such96424812such
sudd64719772sudd
suds56135292suds
sugh86423442sugh
swish115114822swish
swith115917402swith
syph125413272syph
tide55237372tide
tidy86822412tidy
vid77241802vid_
vide85432752vide
vids85627532vids
wich125724742wich
wide85235402wide
width12310962width
wish107228732wish
with105730472with
yid76640822yid_
yids85224952yids
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.1401276364.3
2DLD Change Limit298721432.18613665.1
3Display Results1431430.0632269.8
 (SQL Overall)1786911432.38974797.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.