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

197 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
ski7492570(None) 
ki67537971_ki
saki85628481saki
sei36048931sei
si29149581s_i
ska76925861ska
skid95720941skid
skim105322521skim
skin85927541skin
skip105421761skip
skis84825301skis
skit85437541skit
sky106420991sky
sri35634001sri
ahi68040232ahi
ai211288402_ai
akin86328042akin
ami56646812ami
ani37751182ani
asci66519142asci
ask77130702ask_
askoi9507802askoi
asks85721212asks
bi48046482_bi
chi86228652chi
dui46433382dui
eke75630092eke
ghi77019882ghi
hi57947592_hi
ka69145092_ka
kaki76520922kaki
khi106318312khi
kid86540632_kid
kif105941202_kif
kin76353982_kin
kip97042152_kip
kir76535692_kir
kis78051492_kis
kit78559892_kit
koi77534762koi
lei36846382lei
li29948762_li
mi48249062_mi
obi57127732obi
oi29061492_oi
oka76926802oka
oke75839482oke
phi86524202phi
pi48145372_pi
piki106520572piki
poi57244662poi
psi56621622psi
qi116526912_qi
rai37658222rai
raki87127832raki
rei35647252rei
sab56563202sab
sac57452862sac
sad47459212sad
sadi55834652sadi
sae38365182sae
sag46163402sag
said55742122said
sail45447162sail
sain45551292sain
sake85244962sake
sakis95323672sakis
sal36462882sal
sap56463232sap
sari45444042sari
sat36288482sat
sati45539332sati
sau36356572sau
saw68255352saw
sax107447642sax
say67264762say
sea36161292sea
sec55945322sec
see35772262see
seg45544882seg
seif75638732seif
seis45542392seis
sel38253322sel
semi65127222semi
sen36058522sen
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sh56828522s_h
sha69837782sha
she66837692she
shh97121072shh
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shri76021702shri
shy96728192shy
sib56850322sib
sic55847882sic
sika86021332sika
sike87138792sike
sim56553152sim
sin36265902sin
sip57656022sip
sir35746682sir
sis37360552sis
sit35877762sit
six105339752six
skag96321512skag
skas85325712skas
skat87037902skat
skee85431472skee
skeg95316162skeg
skein94814412skein
skep105219352skep
skew116218762skew
skids104615342skids
skied104417762skied
skier95119602skier
skies95026842skies
skiey125012902skiey
skiff153612812skiff
skill94316732skill
skimo116312552skimo
skimp135411332skimp
skims114517202skims
skink85916862skink
skins94723472skins
skint95629232skint
skips115616612skips
skirl96012922skirl
skirr94810552skirr
skirt95624672skirt
skite95120062skite
skits94721872skits
skive124614122skive
skua86113152skua
slid55828992slid
slim66631962slim
slip67031732slip
slit46250102slit
sly66228562sly
smit65138412smit
snib66522982snib
snip66424652snip
snit46342472snit
so28855442s_o
sob57857942sob
sod46053712sod
soil46138832soil
soke85436262soke
sol37256622sol
soli46637012soli
som59153812som
son37761952son
sop57557862sop
sori46039842sori
sos37761602sos
sot310384302sot
sou37853692sou
sow66554762sow
sox106444192sox
soy67851452soy
spa55730812spa
spic85227432spic
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
spy86023742spy
sris45434152sris
stir45723252stir
sty66227312sty
sub55445552sub
sue35651462sue
suit45649872suit
suk75632972suk
suks85927122suks
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
swig85818022swig
swim96221402swim
syke115420562syke
syli74318982syli
syn67024122syn
ti28448302_ti
tiki87620852tiki
tsk75814732tsk_
tsks86410662tsks
tui37034022tui
uke75727292uke
xi98128172_xi

Search took 4 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 Filter178691140841.216146949.8
2DLD Change Limit140841971.9067389.3
3Display Results1971970.406485.2
 (SQL Overall)1786911973.52850649.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.