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

139 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
skim10532251(None) 
shim95827861shim
sim56553141s_im
ski74925691ski_
skid95720931skid
skimo116312541skimo
skimp135411321skimp
skims114517191skims
skin85927531skin
skip105421751skip
skis84825291skis
skit85437531skit
slim66631961slim
swim96221401swim
aim57858212_aim
akin86328032akin
brim85629372brim
dim68146492_dim
glim76026352glim
grim76929422grim
hakim14311832hakim
him86247662_him
ki67537962_ki_
kid86540622_kid
kif105941192_kif
kin76353972_kin
kip97042142_kip
kir76535682_kir
kis78051482_kis
kit78559882_kit
maim85831492maim
mim76048422_mim
nim57142952_nim
oxim131114052oxim
prim85132202prim
rim56052272_rim
said55742112said
sail45447162sail
sain45551292sain
saki85628482saki_
sakis95323672sakis
scam85932352scam
scrim95419742scrim
scum85924522scum
seam66645972seam
seem65438562seem
sei36048932sei_
seif75638732seif
seis45542392seis
seism75019022seism
semi65127222semi
sham96436362sham
shims104422552shims
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
si29149572s_i_
sib56850312s_ib
sic55847872s_ic
sika86021322sika
sike87138782sike
sima64730782s_ima
simp85228772s_imp
sims65737172s_ims
sin36265892s_in
sip57656012s_ip
sir35746672s_ir
sis37360542s_is
sit35877752s_it
six105339742s_ix
ska76925862sk_a
skag96321512skag
skas85325712skas
skat87037902skat
skee85431472skee
skeg95316162skeg
skein94814412skein
skelm114211292skelm
skep105219352skep
skew116218762skew
skids104615332skids
skied104417752skied
skier95119592skier
skies95026832skies
skiey125012892skiey
skiff153612802skiff
skill94316722skill
skimos12548802skimos
skimps14488042skimps
skimpy17475722skimpy
skink85916852skink
skins94723462skins
skint95629222skint
skips115616602skips
skirl96012912skirl
skirr94810542skirr
skirt95624662skirt
skite95120052skite
skits94721862skits
skive124614112skive
skua86113152skua
sky106420992sk_y
slam67737972slam
slid55828982slid
slime74925752slime
slims75423652slims
slimy105417422slimy
slip67031732slip
slit46250102slit
slum65430512slum
smit65138412smit
snib66522982snib
snip66424652snip
snit46342472snit
soil46138832soil
som59153812s_om
spam85930042spam
spic85227432spic
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
sri35634002sri_
sris45434152sris
stem610628252stem
stime76521802stime
stimy105114742stimy
stir45723252stir
stum65526022stum
suit45649872suit
sum56346012s_um
swam96329982swam
swig85818022swig
swims105514142swims
swum96416822swum
trim65329522trim
vim87437022_vim
whim126220532whim

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.266671770.7
2DLD Change Limit298721390.76638997.4
3Display Results1391390.0304633.3
 (SQL Overall)1786911391.062168258.9
 
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.