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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
hetaeras114673(None) 
hetaera1036491hetaera_
hetaerae1145531hetaerae
hetairas1145601hetairas
heaters104225222heater_s
hetaeric1346762hetaeric
hetaerism1445412hetaerism
hetaira1045902hetaira_
hetairai1143532hetairai
heteros10312682het_eros
aethers103614943aether_s
beaters94925043beater_s
betters94422093better_s
cheaters133613513cheater_s
chimaeras1664573chimaeras
deters74724683det_er_s
eaters65535953_eater_s
etageres936863_etageres
ethers94518413_ether_s
fetters103517903fetter_s
gerberas1144963gerberas
getters84216103getter_s
habaneras1442833habaneras
haeres94017033h__aeres
haftaras14136073hafta_ras
haters94930403hat_er_s
hatterias1258743hatterias
hatters104221523hatter_s
headers113819393header_s
healers104319463healer_s
heapers123616673heaper_s
hearers104319783he_arers
hears86737373he_a_r_s
hearts96218943he_a_rts
heater94828303heater__
heathers143914733heather_s
heavers133717193heaver_s
hectares1338853hecta_res
heders104119763he_der_s
hedgers124310263hedger_s
heeders114213743heeder_s
heelers103815623heeler_s
hefters134312003hefter_s
hegaris11310433hega_ris
hegiras1136103he_giras
heifers1337933heifer_s
hejiras1744233he_jiras
hektares1535813hekta_res
helleris113010183helleris
hellers103619833heller_s
helpers123311853helper_s
hemmers143310843hemmer_s
herders113914123herder_s
hetaerisms1544883hetaerisms
hetairism1444313hetairism
hetero9312633het_er_o
hewers123715273he_wer_s
hexagram2143683hexagram
hexagrams2243093hexagrams
hexaplas2043523hexaplas
hexers165612753he_xer_s
hitters104717593hitter_s
hyaenas1334983h_yaenas
letters73819853letter_s
metameres1347453metameres
metamers1249623metamer_s
metepas1136303met_epas
meters85625833met_er_s
metiers93312843metier_s
netters73618583netter_s
petards104311153peta_rds
peters86624593pet_er_s
petters93722363petter_s
retakers123511133retaker_s
retards85015003reta_rds
retears72814923retear_s
sataras7315063sata_ras
seaters74028943seater_s
setters73822063setter_s
temperas12278233temperas
tethers103815313tether_s
tetras63017623tet__ras
tetters74320473tetter_s
theaters114211903theater_s
tuateras836193tuateras
veteran1039353vet_eran
veterans1148853vet_erans
vetoers10359473vetoer_s
vetters104016323vetter_s
wethers135214693wether_s
wetters103817753wetter_s
wheatears1542683wheatears
whetters14246653whetter_s

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 Filter1786911461620.420425454.8
2DLD Change Limit146162937.86018595.7
3Display Results93930.0332818.2
 (SQL Overall)178691938.31321495.4
 
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.