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

177 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
spaces10472263(None) 
paces96741111_paces
space95325671space_
spaced114517251spaced
spacer104917791spacer
spacers113813871spacers
spacey136212531spacey
spades94222581spades
spaes76029971spa_es
spales84728101spales
spares84834551spares
spates85028171spates
spices104326031spices
aces67645092__aces
apace94718382apace_
apaches143411832apaches
apices104916262apices
braces108427772braces
daces85030682_daces
epacts105010392epacts
faces106439432_faces
glaces94218022glaces
graces94523492graces
laces76141762_laces
maces97139962_maces
pacas96029402_pacas
pace86345772_pace_
paced106931682_paced
pacer96131612_pacer
pacers105124542_pacers
pacey126720282_pacey
packs135528932_packs
pacs85842182_pac_s
pacts95125802_pacts
pages85235072_pages
pales75753802_pales
panes76148692_panes
pares77164482_pares
pases75346502_pases
pates76047892_pates
paves104833922_paves
paxes144928422_paxes
peaces106324082peaces
places104323702places
puces94924632_puces
races74943242_races
respaces12311042respaces
sabes76437462s_abes
sacks114228872s_acks
sacs65739072s_ac_s
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
saices84221802saices
sakes95540752s_akes
sales56055592s_ales
sanes55649072s_anes
sates54949322s_ates
sauces84919502sauces
saves85838632s_aves
saxes125229342s_axes
scales84529312scales
scapes105122262scapes
scares85033002scares
seances93015342seances
shacks154817562shacks
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
sices75637272s_ices
skates104219392skates
slacks124416532slacks
slakes104021882slakes
slates64934062slates
slaves95023022slaves
slices84022852slices
smacks144112322smacks
smazes174311662smazes
snacks124514552snacks
snakes103919602snakes
snares65329032snares
soaves94218672soaves
solaces93116132solaces
spacier114011632spacier
spaciest122310892spaciest
spackles16319942spackles
spacy125415622spac_y
spade84423322spade_
spaded103816752spaded
spader94317132spader
spaders104214472spaders
spadices1336092spadices
spae65034322spa_e_
spaed85522272spa_ed
spahee11313442spahee
spahees1238262spahees
spahis11310382spahis
spails84817822spails
spaits85017472spaits
spake114322742spake_
spale74929212spale_
spalls84217342spalls
spams94922192spa_ms
spancel1147362spancel
spancels1245272spancels
spanks124514122spanks
spans74528732spa_ns
spare75135562spare_
spared95427482spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparges104016332sparges
sparks124616362sparks
spars75431542spa_rs
sparse84516342sparse
spas67036722spa__s
spasms10418972spasms
spate74731582spate_
spathes125116532spathes
spats75031382spa_ts
spavies123012942spavies
spawns11577922spawns
spayed124213612spayed
spays105520512spa_ys
spazzes1735262spazzes
species11314132species
specks144312702specks
specs96916672spec_s
spences113413922spences
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spic_s
spies76037622sp_ies
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
splakes1349672splakes
splices113914382splices
spodes94817432spodes
spokes124417212spokes
spores84726612spores
sprees85620642sprees
spruces113810502spruces
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
stacks124317262stacks
stactes91914632stactes
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stances93715962stances
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
swages104417072swages
swales93920762swales
syces106416462s_yces
taces76237802_taces
traces85329932traces
upases84112902upases

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 Filter178691825510.1061685764.2
2DLD Change Limit825511773.06326951.0
3Display Results1771770.1261404.8
 (SQL Overall)1786911773.29554231.0
 
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.