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

184 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
renter6452741(None) 
center84421411center
enter54726381_enter
ranter63826821ranter
reenter73217791reenter
reinter73116841reinter
render74024141render
rente54733781rente_
rented74426591rented
renters74224811renters
rentes65431191rentes
rentier73618221rentier
rester63832431rester
tenter64623931tenter
venter94218721venter
banter84825332banter
beater84729392beater
belter84720962belter
bender95223302bender
better84723702better
bunter85020382bunter
canter85230112canter
censer84516582censer
centers94420592centers
centner946852centner
centre84316642centre
defter104215922defter
denier74420692denier
denser74115192denser
dented84120512dented
deter65028042de_ter
dexter143810892dexter
eater54639842_eater
ender64325862_ender
entera64216832_entera
enters64425642_enters
erecter93113392erecter
ester54727712_ester
feater95224052feater
fencer114613532fencer
fender103718722fender
fester94723512fester
fetter94120382fetter
fretter103412752fretter
fronter103611582fronter
gender83517932gender
gentes75324162gentes
gentler8378952gentler
getter74117612getter
granter84117132granter
greater84416492greater
greeter82812672greeter
grunter83110782grunter
heater94828302heater
hefter124313922hefter
hented104218752hented
hinter94021302hinter
hunter94817772hunter
inter55028492_inter
jester134319152jester
kelter103214372kelter
kente95821062kente_
kentes105118642kentes
lefter93613432lefter
lender73921272lender
lenten6312882lenten
letter63722582letter
linter64625332linter
meeter83616502meeter
melter83520112melter
mender93520792mender
mentee84121292mentee
mentor8414362mentor
meter75130322me_ter
minter84425102minter
neater64424312neater
nester64124182nester
netter63722022netter
neuter63713792neuter
orienter838312orienter
pelter83321622pelter
penner84616662penner
penster92811952penster
perter84422282perter
pester84827592pester
peter74427592pe_ter
petter83924772petter
pewter114013672pewter
prester93519622prester
printer93917302printer
punter84320022punter
rafter94517582rafter
ranger73925522ranger
ranker105021902ranker
ranted74324702ranted
ranters73323642ranters
raster64731442raster
rater54943282r_ater
ratter64326312ratter
reader73628292reader
realer63528592realer
realter73716312realter
reamer84325212reamer
reaper84223142reaper
rearer64928912rearer
reaver94524732reaver
rebater93517902rebater
recanter101913152recanter
recenter102715442recenter
reciter94117262reciter
rector84019742rector
redder83918132redder
reefer93314362reefer
reeker103715592reeker
reeler63822572reeler
reenters82915302reenters
refer84822142re_fer
refuter104312192refuter
reinters82614772reinters
reiver95318292reiver
relater73723142relater
relier65826182relier
remoter94815972remoter
rended84524102rended
renders83821672renders
reneger8299492reneger
renew83917512ren_ew
renewer10248692renewer
rennet64624852rennet
rent46661242rent__
rental63922022rental
rentiers83311762rentiers
rents55935182rent_s
repenter102813862repenter
rested74430782rested
resters74130402resters
rete44944132re_te_
retear63115482re_tear
retem74221952re_tem
retted74826312retted
reuniter838322reuniter
reutter71010092reutter
ringer74526052ringer
rinser64317212rinser
rioter64817282rioter
ritter63822412ritter
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
runner63814462runner
runtier73512852runtier
seater64534152seater
sender73824412sender
sente56432872sente_
setter64023722setter
sinter63625922sinter
teeter65420312teeter
tender74121842tender
tenner64117102tenner
tenser64919432tenser
tented74221002tented
tenters73921102tenters
tentier73815922tentier
tester64227152tester
tetter64322452tetter
tinter63923642tinter
treater74219832treater
ureter6313202ure_ter
vender103418422vender
veneer94511692veneer
vented104617922vented
venters103717722venters
vetter93417642vetter
wanter94423052wanter
welter93417382welter
wester94222892wester
wetter93919442wetter
winter94222802winter
wrester102812412wrester
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 Limit825511843.04627101.4
3Display Results1841840.0632920.6
 (SQL Overall)1786911843.21955511.3
 
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.