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

264 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
skis8482529(None) 
kis78051471_kis
sakis95323671sakis
seis45542391seis
sis37360541s_is
skas85325711skas
ski74925691ski_
skid95720921skid
skids104615321skids
skies95026831skies
skim105322511skim
skims114517191skims
skin85927531skin
skins94723461skins
skip105421751skip
skips115616601skips
skit85437531skit
skits94721861skits
sris45434151sris
ahis76135382ahis
ais39083572_ais
akin86328032akin
amis66445322amis
anis45746462anis
askos95011772askos
asks85721212ask_s
aspis74618142aspis
axis116127912axis
bis56860662_bis
bris65539612bris
chis95933312chis
cis57748032_cis
cris66233432cris
dais57040702dais
dis46459892_dis
egis56520652egis
ekes86726602ekes
ghis85020162ghis
his66359502_his
ibis66519582ibis
iris45732552iris
is27048212__is
iwis77117012iwis
kakis86116842kakis
kas77058582_kas
khis117017982khis
ki67537952_ki_
kid86540612_kid
kids96029632_kids
kif105941182_kif
kifs116023502_kifs
kin76353962_kin
kins85747902_kins
kip97042132_kip
kips106430512_kips
kir76535672_kir
kirs85831732_kirs
kiss85227392_kiss
kist86540792_kist
kit78559872_kit
kits86441762_kits
kois85129402kois
kos76944822_kos
kris86423602kris
leis45739602leis
lis37162272_lis
mis58162622_mis
obis66226842obis
okas85225392okas
okes84936342okes
phis95724902phis
pikis115116392pikis
pis56362032_pis
pois66539042pois
psis68120342psis
qis126934382_qis
rais45252622rais
rakis95323442rakis
reis45343232reis
sabs66643742sabs
sacs65739072sacs
sadis64930852sadis
sags55948402sags
said55742112said
saids65328852saids
sail45447162sail
sails55738102sails
sain45551292sain
sains55639972sains
sakes95540752sakes
saki85628482saki_
sals46851672sals
sans45153362sans
saps65346372saps
saris54544952saris
sass45035622sass
satis55633682satis
saws75839482saws
says75942102says
seas45755272seas
secs65033892secs
sees45361052sees
segs54933882segs
sei36048932sei_
seif75638732seif
seifs85019332seifs
seise54727852seise
seism75019022seism
sels46345982sels
semis74623532semis
sers45746652sers
sets45549502sets
sews75836022sews
shes75734352shes
shies86136552shies
shim95827862shim
shims104422552shims
shin75634312shin
shins85131042shins
ship95228242ship
ships105123772ships
shist84829612shist
shit76745942shit
shits84731172shits
shiv105721172shiv
shivs115018802shivs
shris84221452shris
si29149572s_i_
sib56850312s_ib
sibs65933542sibs
sic55847872s_ic
sics65234092sics
sika86021322sika
sikas94617022sikas
sike87138782sike
sikes96236082sikes
sim56553142s_im
sims65737172sims
sin36265892s_in
sins46755272sins
sip57656012s_ip
sips65740102sips
sir35746672s_ir
sirs44338332sirs
sit35877752s_it
sits45050202sits
six105339742s_ix
ska76925862sk_a
skag96321512skag
skags104316072skags
skat87037902skat
skats94621542skats
skee85431472skee
skees95023122skees
skeg95316162skeg
skegs105011232skegs
skein94814412skein
skeins103911902skeins
skep105219352skep
skeps115614252skeps
skew116218762skew
skews125413802skews
skied104417752skied
skier95119592skier
skiers104713702skiers
skiey125012892skiey
skiff153612802skiff
skiffs16327012skiffs
skill94316722skill
skills104313922skills
skimo116312542skimo
skimos12548802skimos
skimp135411322skimp
skimps14488042skimps
skink85916852skink
skinks94511652skinks
skint95629222skint
skirl96012912skirl
skirls10449822skirls
skirr94810542skirr
skirrs10448192skirrs
skirt95624662skirt
skirts104111502skirts
skite95120052skite
skites104418042skites
skive124614112skive
skives134113942skives
skosh12407272skosh
skua86113152skua
skuas95611732skuas
sky106420992sk_y
slid55828982slid
slim66631962slim
slims75423652slims
slip67031732slip
slips76023722slips
slit46250102slit
slits56128852slits
smit65138412smit
snib66522982snib
snibs75613762snibs
snip66424652snip
snips75818012snips
snit46342472snit
snits54124832snits
sobs64941752sobs
sods54940212sods
soil46138832soil
soils55327982soils
sokes95031422sokes
sols45448162sols
soms66239372soms
sons46049552sons
sops65244562sops
sos37761602s_os
sots45552452sots
sous46947212sous
sows75342492sows
soys75233932soys
spas67036722spas
spic85227432spic
spics94123242spics
spies76037622spies
spik105419712spik
spiks114117472spiks
spin66231302spin
spins75327982spins
spit65545082spit
spits74429552spits
spiv95917792spiv
spivs105114242spivs
sri35634002sri_
sties55132982sties
stir45723252stir
stirs55921622stirs
subs66037122subs
suds56135292suds
sues46247652sues
suit45649872suit
suits55028052suits
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
swig85818022swig
swigs96213662swigs
swim96221402swim
swims105514142swims
swish115114822swish
swiss86712902swiss
sykes124816862sykes
sylis84316022sylis
this76027382this
tikis95615972tikis
tis37056642_tis
tsks86410662tsk_s
tuis44829642tuis
ukes86122812ukes
vis66747612_vis
wis66552332_wis
xis106935332_xis
ywis105313102ywis

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.283631417.0
2DLD Change Limit298722640.84335435.3
3Display Results2642640.0634190.5
 (SQL Overall)1786912641.189150286.8
 
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.