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

240 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
slid5582898(None) 
lid47453521_lid
said55742111said
sild55030581sild
skid95720931skid
sled55334371sled
slide64725411slide
slim66631961slim
slip67031731slip
slit46250101slit
sloid64619711sloid
solid65025081solid
acid77533392acid
aid49269082_aid
alcid85817972alcid
algid75415582algid
alif76242142alif
alit46155692alit
amid77036352amid
arid57642712arid
avid88325962avid
bid67751812_bid
bled75729312bled
blin67228172blin
blind86319322blind
blip88322772blip
caid77837532caid
chid106626402chid
clad76225822clad
clip86924002clip
clod76124612clod
did56850522_did
eld46733792el_d
elide64922642elide
felid94717172felid
fid76847692_fid
fled85429772fled
flic96223732flic
flied96519432flied
flip96324262flip
flir76422202flir
flit76539272flit
fluid94013962fluid
gelid74916982gelid
gid57047272_gid
gild65526512gild
glad65624012glad
gled65631142gled
glia56423152glia
glib79421442glib
glide74521592glide
glim76026352glim
grid65829612grid
guid66022822guid
halid94424982halid
hid76248382_hid
id38941842__id
ilia46026822ilia
iliad64613462iliad
imid76122292imid
irid55927172irid
isled64615992isled
kid86540622_kid
klik74412652klik
lad48165702_lad
laid56439142laid
led46254552_led
li29948752_li_
lib57750272_lib
lido56028162_lido
lids56336462_lids
lie38264522_lie
lied55838092_lied
lin37967372_lin
lip514755802_lip
lis37162272_lis
lit39377312_lit
loid55531492loid
maid75537662maid
mid67354472_mid
mild75330852mild
old47033462ol_d
olio46829672olio
oxid12815482oxid
paid75737482paid
plaid85118302plaid
pled75231432pled
plie65127392plie
plied85118592plied
plod76723272plod
qaid146023842qaid
quid144922352quid
raid55243072raid
rid46754632_rid
sad47459202s_ad
sadi55834642sadi
saids65328852saids
sail45447162sail
sain45551292sain
salad65321832salad
salic73424712salic
salpid9510882salpid
sand55338472sand
sapid84720932sapid
sard55344242sard
sayid95516722sayid
scad75725772scad
scud76221282scud
seed55549482seed
sei36048932sei_
seif75638732seif
seis45542392seis
send55237292send
shad86230912shad
shed86536152shed
shied96125492shied
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shod86225062shod
si29149572s_i_
sialid7314942sialid
sib56850312s_ib
sic55847872s_ic
side55444492s_ide
sidh86222992s_idh
silds65520522silds
silk85529322silk
sill45545152sill
silo46037912silo
silt46558192silt
sim56553142s_im
sin36265892s_in
sip57656012s_ip
sir35746672s_ir
sis37360542s_is
sit35877752s_it
six105339742s_ix
ski74925692ski_
skids104615332skids
skied104417752skied
skim105322512skim
skin85927532skin
skip105421752skip
skis84825292skis
skit85437532skit
slab67133762slab
slag55934352slag
slain54923572slain
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sleds64418852sleds
slew76228232slew
slice74925822slice
sliced94416312sliced
slick115520522slick
slider73918362slider
slides73922182slides
slier54827242slier
slily85820032slily
slime74925752slime
slimed94915122slimed
slims75423652slims
slimy105417422slimy
sling66028802sling
slink95422912slink
slipe75626132slipe
sliped95417062sliped
slips76023722slips
slipt76627482slipt
slits56128852slits
slob66029422slob
sloe45534952sloe
slog56728272slog
sloids73712692sloids
slojd13378842slojd
slop66533872slop
slot46049832slot
slow77729492slow
sloyd9409682sloyd
slub65428032slub
slue45332192slue
slued64220512slued
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
sly66228562sl_y
smit65138412smit
sned56026052sned
snib66522982snib
snide64318722snide
snip66424652snip
snit46342472snit
sod46053702s_od
soil46138832soil
sold54837412sold
soldi65717202soldi
soled65835172soled
soli46637012soli_
solidi73813152solidi
solids74116402solids
sord56237202sord
sped76031492sped
spic85227432spic
spied85427712spied
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
split75729012split
spud75818492spud
squid154211902squid
sri35634002sri_
sris45434152sris
staid66722082staid
stied65723032stied
stir45723252stir
stolid74213182stolid
stud56220092stud
sudd64719772sudd
sued56537932sued
suit45649872suit
sulfid1039062sulfid
surd56433812surd
swig85818022swig
swim96221402swim
syli74318982syli_
sylis84316022sylis
valid94618392valid
vid77241812_vid
void86220562void
whid115418872whid
wild85126512wild
yid76640832_yid

Search took 2 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.263679433.5
2DLD Change Limit298722400.80037340.0
3Display Results2402400.0604000.0
 (SQL Overall)1786912401.123159119.3
 
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.