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

310 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
yids8522495(None) 
aids57846351aids
bids75838431bids
fids87034731fids
gids65933731gids
ids47535461_ids
kids96029631kids
lids56336451lids
mids76541781mids
rids56539541rids
vids85627531vids
yid76640821yid_
yins75335121yins
yips95226691yips
yirds96612511yirds
yods86531181yods
acids87121002acids
adds67622452adds
ads49755732_ads
aid49269072aid_
aide56044992aide
aides65336602aides
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572ai_s
aits46355532aits
amids85627512amids
ands57833612ands
ayins85321612ayins
bads77048862bads
beds75937782beds
bias64738162bias
bibs84830992bibs
bid67751792bid_
bide76041482bide
bides85536772bides
bidi78226572bidi
bidis86721142bidis
bigs76235022bigs
binds86627472binds
bins66548252bins
bios66335322bios
birds85421332birds
bis56860662bi_s
bits66148162bits
bods76244712bods
buds75235172buds
cads76144522cads
caids85226422caids
cigs75625102cigs
cis57748032ci_s
cods76848102cods
cuds76730472cuds
dads67442772dads
dibs76233682dibs
did56850512did_
dido66528192dido
didos76820812didos
didst74619612didst
didy99121502didy
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dis46459892di_s
diss56434482diss
dits56450522dits
duds65530142duds
dyads10549972dyads
eds46638922_eds
eide55832232eide
eidos65817752eidos
elds56324852elds
ends56528522ends
fads86939872fads
feds85234312feds
fibs96329502fibs
fid76847682fid_
fido87726392fido
fidos95819052fidos
figs85332642figs
fils75838692fils
finds95424822finds
fins75849092fins
firs76637712firs
fits76043462fits
fuds86528562fuds
gads67843382gads
geds66730812geds
gibs75529272gibs
gid57047262gid_
gies55641422gies
gigs66631182gigs
gilds75417522gilds
gins55543952gins
gips75632922gips
girds74816992girds
gits55744592gits
gods65438042gods
grids75321392grids
guids75516152guids
hid76248362hid_
hide85134622hide
hides95129422hides
hies74842832hies
hims95230972hims
hinds96721472hinds
hins76447992hins
hips96433702hips
his66359502hi_s
hiss75629212hiss
hits75545132hits
hods87239862hods
hyoids1377672hyoids
id38941832_id_
ides57734232_ides
ifs67124242_ifs
imids86015142imids
ins35945602_ins
irids66417772irids
is27048212_i_s
its35538832_its
jibs136724082jibs
jigs126524762jigs
jins115635012jins
kid86540612kid_
kifs116023502kifs
kinds106221812kinds
kins85747902kins
kips106430512kips
kirs85831732kirs
kis78051472ki_s
kiss85227392kiss
kits86441762kits
lads56549132lads
libs66732762libs
lid47453512lid_
lido56028152lido
lidos65219882lidos
lies46454192lies
lins47059052lins
lips67141442lips
lis37162272li_s
lits46252492lits
loids66220702loids
mads76845362mads
maids86327142maids
meds75735362meds
mibs85330482mibs
mics87435152mics
mid67354462mid_
midi75628472midi
midis85923412midis
midst85922552midst
migs76935322migs
milds86422052milds
mils66045332mils
minds85427122minds
mips85534082mips
mirs66940572mirs
mis58162622mi_s
miss65339422miss
mods77945052mods
muds75530652muds
mysids1246562mysids
nibs65028312nibs
nide55535782nide
nides65229132nides
nidi56524392nidi
nidus65913572nidus
nils46132452nils
nims66226882nims
nips65830922nips
nits45741642nits
nods55838222nods
odds68919922odds
ods47546212_ods
oils46337972oils
olds55926572olds
ouds56430102ouds
oxids13128962oxids
pads76742952pads
peds75835242peds
pias66542552pias
pics85633912pics
pies66949602pies
pigs76634222pigs
pins65558452pins
pips85837132pips
pis56362032pi_s
piss65033332piss
pits66348742pits
pods76540152pods
puds75630512puds
pyins105815862pyins
qaids156116312qaids
qis126934382qi_s
quids154917462quids
rads56046602rads
raids65827512raids
reds56042862reds
rias45540592rias
ribs65833022ribs
rid46754622rid_
ride55945122ride
rides66140812rides
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rinds64826142rinds
rins46153192rins
rips66237432rips
rods56442062rods
rynds9569972rynds
saids65328852saids
sayids104310972sayids
sibs65933542sibs
sics65234092sics
side55444482side
sides65838362sides
sidh86222982sidh
silds65520522silds
sims65737172sims
sins46755272sins
sips65740102sips
sirs44338332sirs
sis37360542si_s
sits45050202sits
skids104615322skids
sods54940212sods
suds56135292suds
tads57143942tads
teds54932572teds
tics65729632tics
tide55237372tide
tides64830152tides
tidy86822412tidy
ties45248312ties
tils45739612tils
tins45251302tins
tips66436762tips
tis37056642ti_s
tits46145032tits
tods56141842tods
urds55922422urds
vid77241802vid_
vide85432752vide
vies75238622vies
vigs85427272vigs
vims95423312vims
vis66747612vi_s
voids95414672voids
wads87343142wads
weds86628932weds
whids125413982whids
wide85235402wide
wides94832822wides
wigs84931252wigs
wilds94818202wilds
winds95425602winds
wins75949172wins
wis66552332wi_s
wiss75630542wiss
wits76044872wits
wynds126310372wynds
xis106935332xi_s
yags86632292yags
yairds10448022yairds
yaks116025202yaks
yams95330732yams
yaps95933522yaps
yards95324612yards
yauds95013222yauds
yaws105531212yaws
yays105728912yays
yeas78638422yeas
yens75832262yens
yeps95924402yeps
yes66250612y_es
yews105323962yews
yields10466842yields
yikes125117752yikes
yill75628972yill
yills83921552yills
yin67648732yi_n
yip87241172yi_p
yipe96722172yipe
yipes106017842yipes
yird87018982yird
yirr76513572yirr
yirrs8469192yirrs
yobs96028082yobs
yod77545502yod_
yodh119916102yodh
yodhs12669012yodhs
yoks116223742yoks
yous76230652yous
yows106433122yows
yuks116418022yuks
yups96121602yups
ywis105313102ywis
zeds145821802zeds
zigs145422792zigs
zins135735002zins
zips155723792zips
zits136030292zits

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.0762351197.4
2DLD Change Limit298723101.00029872.0
3Display Results3103100.0634920.6
 (SQL Overall)1786913101.139156884.1
 
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.