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

161 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
hetaera103649(None) 
hetaerae1145531hetaerae
hetaeras1146731hetaeras
hetaira1045901hetaira
heater94828302heater_
heaters104225222heaters
hetaeric1346762hetaeric
hetairai1143532hetairai
hetairas1145602hetairas
hetero9312632het_ero
aether94213673aether_
aethers103614943aethers
beater84729393beater_
beaters94925043beaters
better84723703better_
betters94422093betters
cheater124816963cheater_
cheaters133613513cheaters
chimaera1564943chimaera
deter65028043det_er_
deters74724683det_ers
eater54639843_eater_
eaters65535953_eaters
eatery95316353_eatery
entera64216833_entera
etagere836533_etagere
ether84518773_ether_
ethers94518413_ethers
feater95224053feater_
fetter94120383fetter_
fetters103517903fetters
genera71211713ge_nera
gerbera1034773gerbera
getter74117613getter_
getters84216103getters
habanera1343273habanera
haftara13136093hafta_ra
hater85034753hat_er_
haters94930403hat_ers
hatter94724873hatter_
hatteria1137863hatteria
hatters104221523hatters
header104422543header_
headers113819393headers
healer94221803healer_
healers104319463healers
heaper114119523heaper_
heapers123616673heapers
hear76143883he_a_r_
heard95222753he_a_rd
hearer94323643he_arer
hearers104319783hearers
hears86737373he_a_rs
heart85440743he_a_rt
heated104525593heate_d
heather133914853heather_
heathers143914733heathers
heathery17349083heathery
heaver124819673heaver_
heavers133717193heavers
hectare1238463hecta_re
hectares1338853hectares
heder95623643he_der_
heders104119763he_ders
hedger114912653hedger_
hedgers124310263hedgers
heeder104216043heeder_
heeders114213743heeders
heeler93917313heeler_
heelers103815623heelers
hefter124313923hefter_
hefters134312003hefters
heftier1337203heftier_
hegari1039523hega_ri
hegira1036523he_gira
heifer1238203heifer_
heifers1337933heifers
hejira1644803he_jira
hektare1435503hekta_re
hektares1535813hektares
heller93322513heller_
helleri10389973helleri
hellers103619833hellers
hellery13329213hellery
helper114313093helper_
helpers123311853helpers
hemmer134112643hemmer_
hemmers143310843hemmers
hennery1335303hennery
hepper133412663hepper_
herder104516463herder_
herders113914123herders
hetaerism1445413hetaerism
heteros10312683het_eros
hewer115719933he_wer_
hewers123715273he_wers
hexagram2143683hexagram
hexahedra2352633hexahedra
hexapla1943343hexapla
hexer155116683he_xer_
hexers165612753he_xers
hither124417253hither_
hitter94419863hitter_
hitters104717593hitters
hotter94720083hotter_
hyaena1235363h_yaena
letter63722583letter_
letters73819853letters
megara9310093mega_ra
metamer1139613metamer_
metamere1257353metamere
metamers1249623metamers
metazoa1845543metazoa
metepa1066013met_epa
meter75130323met_er_
meters85625833met_ers
metier83517693metier_
metiers93312843metiers
neater64424313neater_
nether94014163nether_
netter63722023netter_
netters73618583netters
petard95013803peta_rd
peter74427593pet_er_
peters86624593pet_ers
petter83924773petter_
petters93722363petters
retaker113714313retaker_
retakers123511133retakers
retard75018933reta_rd
retear63115483retear_
retears72814923retears
satara6315533sata_ra
seater64534163seater_
seaters74028943seaters
setae56026223setae__
setter64023723setter_
setters73822063setters
tempera11329043tempera
tessera736333tessera
tether93716103tether_
tethers103815313tethers
tetra53417953tet__ra
tetter64322453tetter_
tetters74320473tetters
theater104014253theater_
theaters114211903theaters
tuatera756373tuatera
veteran1039353vet_eran
vetoer93410063vetoer_
vetoers10359473vetoers
vetter93417643vetter_
vetters104016323vetters
wether123315393wether_
wethers135214693wethers
wetter93919443wetter_
wetters103817753wetters
wheatear1442563wheatear
whether16346623whether_
whetter13348803whetter_
whetters14246653whetters

Search took 8 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.390458182.1
2DLD Change Limit1340271617.31318327.2
3Display Results1611610.0463500.0
 (SQL Overall)1786911617.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.