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

182 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
center8442141(None) 
canter85230111canter
censer84516581censer
centers94420591centers
centner946851centner
centre84316641centre
enter54726381_enter
renter64527411renter
tenter64623931tenter
venter94218721venter
banter84825332banter
beater84729392beater
belter84720962belter
bender95223302bender
better84723702better
bunter85020382bunter
cancer104220922cancer
caner75334772can_er
canker124422522canker
canner84625982canner
canoer85121072canoer
canted94825782canted
canters94827722canters
cantor85621522cantor
carter84932272carter
caster85232572caster
cater74840702c_ater
ceder85322232ce_der
ceiler84013962ceiler
cementer1239192cementer
cenote83715842cenote_
cenotes92814542cenotes
cense75121402cense_
censed94016322censed
censers94313902censers
censes83721802censes
censor84011282censor
cent67451012cent__
centai84814782centai
cental84420962cental
centare93113702centare
centas85020702centas
centaur935782centaur
centered112513522centered
centners1057242centners
cento76625172cent_o
centos85920462centos
centra84113882centra
centred103411682centred
centres93817122centres
cents74730332cent_s
centu76119412cent_u
centum104012362centum
century1237192century
certes84623082certes
cete64934782ce_te_
cetes75731102ce_tes
chanter123919732chanter
cheater124816952cheater
chunter123911472chunter
cinder94119122cinder
citer74827322c_iter
coater84329552coater
cointer93616722cointer
colter84625092colter
confer114018682confer
conger95024272conger
conker124721552conker
conner84423962conner
conte76633202conte_
contes84432912contes
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
counter94220142counter
couter84930202couter
crater85026632crater
cunner83915002cunner
curter85320072curter
cuter74728222c_uter
cutter84520992cutter
decenter112412162decenter
defter104215922defter
denier74420692denier
denser74115192denser
dented84120512dented
deter65028042de_ter
dexter143810892dexter
eater54639842_eater
ender64325862_ender
entera64216832_entera
enters64425642_enters
ester54727712_ester
feater95224052feater
fencer114613532fencer
fender103718722fender
fester94723512fester
fetter94120382fetter
gender83517932gender
gentes75324162gentes
gentler8378952gentler
getter74117612getter
heater94828302heater
hefter124313922hefter
hented104218752hented
hinter94021302hinter
hunter94817772hunter
incenter102212092incenter
inter55028492_inter
jester134319152jester
kelter103214372kelter
kente95821062kente_
kentes105118642kentes
lefter93613432lefter
lender73921272lender
lenten6312882lenten
letter63722582letter
linter64625342linter
meeter83616502meeter
melter83520112melter
mender93520792mender
mentee84121292mentee
mentor8414362mentor
meter75130322me_ter
minter84425102minter
neater64424312neater
nester64124182nester
netter63722022netter
neuter63713792neuter
pelter83321622pelter
penner84616662penner
penster92811952penster
perter84422282perter
pester84827592pester
peter74427592pe_ter
petter83924772petter
pewter114013672pewter
punter84320022punter
ranter63826822ranter
recenter102715442recenter
reenter73217792reenter
reinter73116842reinter
render74024142render
rente54733782rente_
rented74426592rented
renters74224812renters
rentes65431192rentes
rentier73618222rentier
rester63832432rester
scanter94215182scanter
scented102811882scented
scepter1138352scepter
seater64534152seater
sender73824412sender
sente56432872sente_
setter64023722setter
sinter63625922sinter
teeter65420312teeter
tender74121842tender
tenner64117102tenner
tenser64919432tenser
tented74221002tented
tenters73921102tenters
tentier73815922tentier
tester64227152tester
tetter64322452tetter
tinter63923642tinter
vender103418422vender
veneer94511692veneer
vented104617922vented
venters103717722venters
vetter93417642vetter
wanter94423052wanter
welter93417382welter
wester94222892wester
wetter93919442wetter
winter94222802winter
yente86220042yente_
yentes95517602yentes
yester93417982yester
zester153617792zester

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 Limit825511823.04627101.4
3Display Results1821820.1261444.4
 (SQL Overall)1786911823.28254445.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.