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

174 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
places10432370(None) 
glaces94218021glaces
laces76141761_laces
paces96741111p_aces
palaces114216451palaces
peaces106324081peaces
place94824611place_
placed114318001placed
placer105117741placer
placers114515261placers
placet103923671placet
placets113911221placets
placks144414151placks
plages94520151plages
plaices11411141plaices
planes85028081planes
plates85432241plates
aces67645092__aces
alates64833962alates
anlaces92313732anlaces
blacks144914952blacks
blades95221252blades
blames105121862blames
blares85021632blares
blazes174817352blazes
braces108427772braces
calces104420052calces
clachs133511322clachs
clacks144516342clacks
clades94920462clades
claves115020062claves
daces85030682_daces
elates65032362elates
emplaces1438412emplaces
enlaces92313392enlaces
faces106439432_faces
falces115216002falces
flacks154114532flacks
flakes134118872flakes
flames114723692flames
flanes94522422flanes
flares94521702flares
flaxes165015352flaxes
glace87420152glace_
glacis94012132glacis
glades84820342glades
glances104113142glances
glares75518862glares
glazes165315642glazes
graces94523492graces
inlaces92512902inlaces
lace66848472_lace_
laced87132642_laced
lacer75833752_lacer
lacers85225252_lacers
lacey105820912_lacey
laches116528342_laches
lacks116129202_lacks
lacs66942482_lac_s
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lances84824102_lances
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
laves86039152_laves
laxes125430092_laxes
lazes145129572_lazes
luces75528432_luces
maces97139962_maces
pacas96029402p_acas
pace86345772p_ace_
paced106931682p_aced
pacer96131612p_acer
pacers105124542p_acers
pacey126720282p_acey
packs135528932p_acks
pacs85842182p_ac_s
pacts95125802p_acts
pages85235072p_ages
palace104516912palace_
palaced124110772palaced
palates93624932palates
pales75753802p_ales
panes76148692p_anes
pares77164482p_ares
pases75346502p_ases
pates76047892p_ates
paves104833922p_aves
paxes144928422p_axes
peace95026082peace_
peaced115818912peaced
peaches144120052peaches
peages94321842peages
peases85229472peases
pelages10714612pelages
phages125213512phages
phases114618402phases
pieces104217272pieces
placates12311752placates
placebo1343292placebo
placebos1443712placebos
placid114012542placid
plack135017842plac_k
placket15412872placket
plackets1646582plackets
plage84520402plage_
plagues103311062plagues
plaice10311552plaice_
plaids94312442plaids
plains85019592plains
plaits83816472plaits
planches153111862planches
plane74929142plane_
planed94420912planed
planer84122652planer
planers94517942planers
planet84228352planet
planets93914082planets
planks124116752planks
plans75731272pla_ns
plants84921802plants
plaques18317892plaques
plashes124417392plashes
plasms103711332plasms
plate74635112plate_
plated95225772plated
platen84518202platen
platens94213982platens
plater84427692plater
platers93924082platers
platies93722542platies
plats75531372pla_ts
platys11459852platys
playas114612282playas
played124815032played
player115215212player
players124313762players
plays106320772pla_ys
plazas17409912plazas
pleaches153210432pleaches
pleases94515482pleases
plebes104313622plebes
plexes155313532plexes
plies74526512pl_ies
plucks14379732plucks
plumes104318132plumes
pluses83618072pluses
poaches144416942poaches
polices113118052polices
pomaces132712122pomaces
ponces104720842ponces
prances113618772prances
prases84429022prases
prates84633162prates
praxes156215182praxes
prices104524542prices
puces94924632p_uces
races74943242_races
relaces93420882relaces
replaces123114122replaces
slacks124416532slacks
slakes104021882slakes
slates64934062slates
slaves95023022slaves
slices84022852slices
solaces93116132solaces
spaces104722632spaces
splakes1349672splakes
splices113914382splices
taces76237802_taces
traces85329932traces
unlaces92513622unlaces

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 Filter178691825510.1101624463.6
2DLD Change Limit825511742.97027794.9
3Display Results1741740.0632761.9
 (SQL Overall)1786911743.14356853.6
 
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.