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

120 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
stilt5483198(None) 
atilt54828471atilt
silt46558191s_ilt
spilt75532221spilt
stile54931571stile
still54922071still
stilts67915301stilts
stint57037661stint
tilt46252421_tilt
built74325922built
gilt56348542_gilt
guilt65125572guilt
hilt75850712_hilt
jilt115839422_jilt
kilt86144412_kilt
lilt46349942_lilt
milt65455812_milt
quilt144125102quilt
sail45447162sail_
sails55738102sails
saint55147072saint
salt45758522s_alt
sault55834962sault
shalt85534482shalt
shift114225132shift
shill85325332shill
shily115222012shily
shirt84533892shirt
shist84829602shist
shit76745932shi_t
sift710740662s_ift
sild55030582s_ild
silk85529322s_ilk
sill45545152s_ill
silo46037912s_ilo
silts55330822s_ilts
silty84721632s_ilty
sit35877752s_i_t
skill94316722skill
skint95629222skint
skirt95624662skirt
skit85437522ski_t
slily85820032slily
slipt76627482slipt
slit46250102sli_t
smalt74729332smalt
smelt74726782smelt
smile74823922smile
smit65138412smi_t
smolt74824162smolt
snit46342472sni_t
soil46138822soil_
soils55327982soils
spelt75430192spelt
spile75230082spile
spill74821162spill
spilth11469732spilth
spirt75032952spirt
spit65545082spi_t
split75729012split
spoilt85016592spoilt
stale55637102stale
stalk94518002stalk
stall54722352stall
start55642312start
stat47352692st_at
stela54019042stela
stele55026842stele
stent55634512stent
stet45947322st_et
stich104117922stich
stick115121562stick
stied65723032stied
sties55132982sties
stiff114219242stiff
stifle93611902stifle
stiles64328762stiles
stills64118562stills
stilly93714072stilly
stilted83511472stilted
stime76521792stime
stimy105114732stimy
sting65330242sting
stink95122502stink
stints65119762stints
stipe76523372stipe
stir45723242sti_r
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
stoat57135952stoat
stole54928812stole
stopt76528352stopt
stot46347322st_ot
stott56929782stott
stout57434052stout
strict84821042strict
stript85222192stript
strut56030732strut
stull54916272stull
stunt55328172stunt
sturt56028962sturt
style85519362style
stylet94018572stylet
styli83911172styli
suint55638182suint
suit45649872sui_t
swift116818052swift
swill83417372swill
til36350262_til_
tile45451442_tile
till45941202_till
tils45739612_tils
tilth85515362_tilth
tilts55325612_tilts
tint46758862_tint
tit36771042_ti_t
uptilt8410802uptilt
utile54718932utile
wilt76246292_wilt

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 Filter178691538000.1061685764.2
2DLD Change Limit538001201.78330173.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911201.93592346.8
 
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.