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

186 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
skier9511959(None) 
kier86526801_kier
shier85428941shier
siker95326031siker
skied104417751skied
skiers104713691skiers
skies95026831skies
skiey125012891skiey
skirr94810541skirr
skiver134612101skiver
slier54827241slier
spier75728031spier
ashier94714832ashier
asker96418782ask_er
bier65531822_bier
biker116022562biker
boskier13309172boskier
brier74527402brier
cakier123115242cakier
crier74724462crier
diker105524552diker
drier64423962drier
duskier12409422duskier
esker94412982esk_er
flier86023402flier
frier85225842frier
hiker125119392hiker
hokier134214032hokier
huskier14369752huskier
icier74313742icier
ickier12439912ickier
inkier104013772inkier
jokier17618752jokier
keir86217872_keir
kief117128392_kief
kiers95320092_kiers
kir76535672_ki_r
kiter95523212_kiter
lakier104716272lakier
lier45942462_lier
liker95627062liker
muskier134312722muskier
oakier104011392oakier
osier53518012osier
peskier13319112peskier
pier66035292_pier
piker115622842piker
plier75221282plier
pokier124914632pokier
prier75027762prier
riskier1138422riskier
saber75330242saber
safer84721812safer
sager65432052sager
sagier73717162sagier
sailer63526102sailer
saker95132022saker
saner54334322saner
sarkier113413312sarkier
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seder64826752seder
seer45547042s_eer
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
ser36752402s__er
serer55935502serer
sever85426052sever
sewer84426212sewer
sexier13310682sexier
shakier143411152shakier
sheer84726892sheer
shied96125492shied
shiel811023772shiel
shiers94921752shiers
shies86136552shies
shiner93820872shiner
shire84727132shire
shirr84716922shirr
shiver124517372shiver
shoer84722152shoer
shyer114714782shyer
sieur5911892s_ieur
sike87138782sike_
sikes96236082sikes
silkier114411642silkier
sir35746672s_i_r
sire46150412s_ire
siver85728612siver
sizer145521812sizer
sizier1514813392sizier
skater105015482skater
skee85431472sk_ee
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skeg95316162sk_eg
skein94814402skein
skep105219352sk_ep
skew116218762sk_ew
skewer13519602skewer
ski74925682ski__
skid95720912ski_d
skidder1365732skidder
skids104615322skids
skiff153612792skiff
skill94316722skill
skim105322492ski_m
skimmer15327532skimmer
skimo116312532skimo
skimp135411312skimp
skims114517182skims
skin85927522ski_n
skink85916852skink
skinker10319442skinker
skinner11348092skinner
skins94723462skins
skint95629222skint
skip105421742ski_p
skipper15339562skipper
skips115616602skips
skirl96012912skirl
skirrs10448192skirrs
skirt95624662skirt
skirter11338482skirter
skis84825282ski_s
skit85437522ski_t
skite95120042skite
skited114313472skited
skites104418032skites
skits94721852skits
skitter113810392skitter
skive124614112skive
skived14429892skived
skivers14409692skivers
skives134113942skives
skiwear1442522skiwear
skyed13529922skyed
skyey15537222skyey
slicer84117602slicer
slider73918362slider
sliver94116592sliver
slyer85515122slyer
smiler83916682smiler
smiter83616412smiter
smokier1356702smokier
snakier112810002snakier
sneer54919952sneer
snider74413912snider
sniper84413642sniper
sober74822402sober
sorer56236572sorer
sower85229312sower
speer74623902speer
speir75315362speir
spicer104719312spicer
spider94516802spider
spied85427712spied
spiel74623912spiel
spiers84421742spiers
spies76037622spies
spiker124315662spiker
spikier13369982spikier
spire75828692spire
sprier84119062sprier
steer55423862steer
stied65723032stied
sties55132982sties
stir45723242sti_r
stiver93915732stiver
suber74924502suber
suckier133613972suckier
suer45334032s_uer
suiter64121812suiter
sulkier113811962sulkier
super74924482super
surer54833092surer
sweer84918572sweer
tier44936142_tier
trier54328532trier
twier84713292twier
vier75428152_vier
wrier84521752wrier

Search took 5 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 Filter178691538000.0931921408.6
2DLD Change Limit538001863.69014579.9
3Display Results1861860.1701094.1
 (SQL Overall)1786911863.95345203.9
 
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.