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

173 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
skid9572093(None) 
kid86540621_kid
said55742111said
ski74925691ski_
skids104615331skids
skied104417751skied
skim105322511skim
skin85927531skin
skip105421751skip
skis84825291skis
skit85437531skit
slid55828981slid
acid77533392acid
aid49269082_aid
akin86328032akin
amid77036352amid
arid57642712arid
asked106919312asked
avid88325962avid
bid67751812_bid
caid77837532caid
chid106626402chid
did56850522_did
eked96718022eked
fid76847692_fid
gid57047272_gid
grid65829612grid
guid66022822guid
hid76248382_hid
id38941842__id
imid76122292imid
irid55927172irid
ki67537962_ki_
kids96029642_kids
kif105941192_kif
kin76353972_kin
kind96128562_kind
kip97042142_kip
kir76535682_kir
kis78051482_kis
kit78559882_kit
laid56439142laid
lid47453522_lid
loid55531492loid
maid75537662maid
mid67354472_mid
oxid12815482oxid
paid75737482paid
qaid146023842qaid
quid144922352quid
raid55243072raid
rid46754632_rid
sad47459202s_ad
sadi55834642sadi
saids65328852saids
sail45447162sail
sain45551292sain
saki85628482saki_
sakis95323672sakis
sand55338472sand
sapid84720932sapid
sard55344242sard
sayid95516722sayid
scad75725772scad
scud76221282scud
seed55549482seed
sei36048932sei_
seif75638732seif
seis45542392seis
send55237292send
shad86230912shad
shed86536152shed
shied96125492shied
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shod86225062shod
si29149572s_i_
sib56850312s_ib
sic55847872s_ic
side55444492s_ide
sidh86222992s_idh
sika86021322sika
sike87138782sike
sild55030582sild
sim56553142s_im
sin36265892s_in
sip57656012s_ip
sir35746672s_ir
sis37360542s_is
sit35877752s_it
six105339742s_ix
ska76925862sk_a
skag96321512skag
skald104210172skald
skas85325712skas
skat87037902skat
skee85431472skee
skeed105018982skeed
skeg95316162skeg
skein94814412skein
skep105219352skep
skew116218762skew
skiddy1533632skiddy
skidoo1136092skidoo
skier95119592skier
skies95026832skies
skiey125012892skiey
skiff153612802skiff
skill94316722skill
skimo116312542skimo
skimp135411322skimp
skims114517192skims
skink85916852skink
skins94723462skins
skint95629222skint
skips115616602skips
skirl96012912skirl
skirr94810542skirr
skirt95624662skirt
skite95120052skite
skited114313482skited
skits94721862skits
skive124614112skive
skived14429892skived
skua86113152skua
sky106420992sk_y
skyed13529922skyed
sled55334372sled
slide64725412slide
slim66631962slim
slip67031732slip
slit46250102slit
sloid64619712sloid
smit65138412smit
sned56026052sned
snib66522982snib
snide64318722snide
snip66424652snip
snit46342472snit
sod46053702s_od
soil46138832soil
sold54837412sold
solid65025082solid
sord56237202sord
sped76031492sped
spic85227432spic
spied85427712spied
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
spud75818492spud
squid154211902squid
sri35634002sri_
sris45434152sris
staid66722082staid
stied65723032stied
stir45723252stir
stud56220092stud
sudd64719772sudd
sued56537932sued
suit45649872suit
surd56433812surd
swig85818022swig
swim96221402swim
tsked105910032tsked
vid77241812_vid
void86220562void
whid115418872whid
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.423422437.4
2DLD Change Limit298721730.82636164.6
3Display Results1731730.0335242.4
 (SQL Overall)1786911731.282139384.6
 
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.