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 “tempera” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

241 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
tempera1132904(None) 
temper103914091temper_
temperas12278231temperas
tempers113513011tempers
tempura11295251tempura
empery1348682_empery
lempira1144192lempira
tamper104618512tamper_
tampers113516742tampers
temped113912892tempe_d
tempeh13357462tempe_h
tempehs14325152tempehs
temperate1348502temperate
tempered13248212tempered
temperer12227722temperer
tempest1139222tempest
templar1145642templar
temporal1246332temporal
tempter11358212tempter_
tempters12257292tempters
tempuras12295062tempuras
tephra1136482te_phra
tessera736332tessera
ampere10514413_ampere
atemporal1343143atemporal
attemper12103633attemper_
attempers13103503attempers
beeper103714093beeper_
beepers113612383beepers
bumper123714343bumper_
bumpers133912053bumpers
camera10313673cam_era
camper124722213camper_
campers134220283campers
compere134616623compere
damper114117753damper_
dampers123915693dampers
deeper93613503deeper_
deperm1139363de_perm
dumper114615213dumper_
dumpers123412663dumpers
ember95516793_ember_
embers104116173_embers
emeer74815363_emeer_
emeers83314183_emeers
emery104814333_em_ery
emmer94314463_emmer_
emmers104013223_emmers
emperor1155483_emperor
empire1039313_empire
emporia1148753_emporia
empyema1642643_empyema
entera64216833_entera
expert15515353_expert
femora1149583fem_ora
genera71211713ge_nera
gerbera1034773gerbera
hamper134518653hamper_
hampers143616943hampers
heaper114119523heaper_
heapers123616673heapers
helper114313093helper_
helpers123311853helpers
hemmer134112643hemmer_
hemmers143310843hemmers
hempen1338963hempe_n
hempier14319003hempier_
hepper133412663hepper_
hetaera1036493hetaera
humper134115883humper_
humpers142713523humpers
imperia1148423_imperia
jeepers16399193jeepers
jimper17389863jimper_
jumper173612373jumper_
jumpers18399843jumpers
keeper123811913keeper_
keepers133410983keepers
lampers113817333lampers
leaper88118943leaper_
leapers93716663leapers
lempiras1243853lempiras
leper74820743le_per_
lepers84817323le_pers
limper104117853limper_
limpers113815223limpers
lumper103816653lumper_
lumpers113514483lumpers
member12258853member_
members13258603members
mumper123513523mumper_
mumpers133311363mumpers
nepeta837893ne_peta
opera7313573__opera
pamper124316663pamper_
pampero13328093pampero
pampers133615933pampers
peeper103614803peeper_
peepers113713673peepers
pepper93512943pepper_
peppers103311443peppers
peppery13286243peppery
puerpera1242853puerpera
pumper124415553pumper_
pumpers133113673pumpers
reaper84223143reaper_
reapers93520453reapers
remora8414583rem_ora
reperk122511773re_perk
retemper1235183retemper_
retempers1345023retempers
romper104213683romper_
rompers113412243rompers
sempre102710093semp_re
simper103616293simper_
simpers113014113simpers
stamper113714393stamper_
stampers124211593stampers
steeper93812773steeper_
steepers103011373steepers
stemmer113210183stemmer_
stemmers12378443stemmers
stemmery15334693stemmery
stepper113010853stepper_
steppers12289273steppers
stomper114111223stomper_
stompers123610033stompers
stumper113610093stumper_
stumpers12318313stumpers
tambura11326463tambura
tamer75230103tam_er_
tamers84224033tam_ers
tampala1136613tampala
tamped114317043tampe_d
tampered13279463tampered
tamperer12248893tamperer
taper74829773t_aper_
tapers84025813t_apers
tapeta8310693t_apeta
tapper104419613tapper_
tappers113416543tappers
tearer64822903tearer_
tearers75218233tearers
teaser65421523teaser_
teasers75317243teasers
tedder83312153tedder_
tedders94010233tedders
teemer85515743teemer_
teemers95012903teemers
teener64717503teener_
teeners74415453teeners
teepee8314363teepe_e
teepees939263teepees
teeter65420313teeter_
teeters74018303teeters
telega736773te_lega
teleran7510173te_leran
telfer9379893telfer_
telfers10299073telfers
teller63519813teller_
tellers73717583tellers
telpher1235563telpher_
telphers1335473telphers
temp85323333temp___
temperable1645813temperable
temperance1644803temperance
temperers13247023temperers
tempering1438733tempering
tempests1234443tempests
tempi94912203temp__i
temping122710693temping
templars1255263templars
temple102811333temp_le
templed12278553templed
temples112610893temples
templet112712003templet
templets12226143templets
tempo95214973temp__o
temporals1345293temporals
temporary1653203temporary
tempos103812293temp_os
temps95417133temp__s
tempt95124843temp__t
tempted12317283tempted
tempts10439453temp_ts
tender74121843tender_
tenders83719723tenders
tenner64117103tenner_
tenners74014923tenners
tenser64919433tenser_
tenter64623933tenter_
tenters73921103tenters
tepa66021683te_p__a
tepee74724213te_pe_e
tepees84215243te_pees
tepefy1434803te_pefy
tephras1236283te_phras
termer85717253termer_
termers95414503termers
terpene92310853terpene
terra54419653te__rra
terser67317823terser_
tesserae844793tesserae
tester64227153tester_
testers74124543testers
tether93716103tether_
tethers103815313tethers
tetra53417953te__tra
tetter64322453tetter_
tetters74320473tetters
thumper14356953thumper_
thumpers15365713thumpers
timber104012673timber_
timbers113111833timbers
timbery14256873timbery
timer75626043tim_er_
timers84420993tim_ers
timpana11226123timpana
tipper103918413tipper_
tippers113414343tippers
toper75231023t_oper_
topers85025323t_opers
topper103817603topper_
toppers113914603toppers
tramper113812153tramper_
trampers123210373trampers
trumpery1533613trumpery
tuatera756363tuatera
tumped114216233tumpe_d
tympana14255853tympana
vamper134212653vamper_
vampers143111623vampers
vesper1138083vesper_
vesperal1344883vesperal
vespers1239033vespers
weeper114313303weeper_
weepers123511973weepers
womera11137593wom_era
wommera14144063wommera
yelper11458783yelper_
yelpers12348203yelpers

Search took 9 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 Filter1786911340270.236757165.3
2DLD Change Limit1340272417.89016986.9
3Display Results2412410.1701417.6
 (SQL Overall)1786912418.29621539.4
 
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.