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

204 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
agapae938804(None) 
agapai9456841agapai
agape85614841agap_e
agama85815572agama_
agamas97413442agamas
agapes95212412agapes
agate66525142aga_te
agave95314032aga_ve
agaze156113662aga_ze
agorae7511202agorae
gape75134512_gap_e
abaca95118043abaca_
abacas104414723abacas
abaka114313823abaka_
abakas123911743abakas
abase76023483aba_se
abate76627843aba_te
abaya104413173abaya_
abayas114011703abayas
adage7414053ada_ge
adapt81218553adap_t
adapted1135833adapted
adapter1036173adapter
adapts9107813adapts
aga410447233ag__a_
again65218113aga_in
agamete1037393agamete
agamic113110543agamic
agamid103710673agamid
agapeic1244703agapeic
agar58726413ag__ar
agaric93513623agaric
agarose838653agarose
agars66120643aga_rs
agas55938843ag__as
agates76121333agates
agatize1739833agatize
agaves104611513agaves
age47154333ag___e
agee56241493ag__ee
agemate101210583agemate
agene65621583ag_ene
aggada955203aggada_
aggadah1362833aggadah
aggadas1054983aggadas
aggie73415013ag_gie
aggrade1035633aggrade
agha87417303ag_ha_
aghas97014873ag_has
agile65122263ag_ile
agita6315423agita_
agitas7310593agitas
agitate8312063agitate
aglare7312423aglare
agleam9158623agleam
aglee65728493ag_lee
agma77623263ag_ma_
agmas85919873ag_mas
agnate73314873agnate
agnize16329563agnize
agonal7410053agonal
agone65924553ag_one
agora6914333agora_
agoras7613343agoras
agrafe1038093agrafe
agraffe1443333agraffe
agrapha1345133agrapha
agree65226033ag_ree
agria65517143agria_
agrias74315393agrias
aguacate1144963aguacate
ague55725923ag__ue
alae45643753__alae
alane56135613ala_ne
alate55340323ala_te
algae65319623a_lgae
alulae6312743alulae
amaze166016603ama_ze
amebae1049633amebae
ample94720303a_mple
anabas8314083anabas
ananke1038283ananke
anapaest1046023anapaest
anaphase1345463anaphase
anatase738943anatase
ansae55720973a_nsae
antae56828293a_ntae
aortae65115473aortae
apace94718383apa_ce
apache134210773apache
apanage1036803apanage
ape57251183__ap_e
appal95315223a_ppal
apple94517673a_pple
apse67725383__apse
aquae142212713a_quae
arable81821003arable
arame75026623ara_me
areae55229743a_reae
arepa75615563arepa_
arepas85515703arepas
argala74712663argala_
argalas84011083argalas
asana5315483asana_
asanas6514113asanas
atabal839743atabal
ataman81013063ataman
atap66722453atap__
ataps76414833atap_s
aurae54128113a_urae
avatar937523avatar
awake125014783awa_ke
aware86420023awa_re
azalea1537003azalea
bagasse1035143bagasse
canape10913513canap_e
cape87242783_cap_e
carapace1446083carapace
carapax1835793carapax
chape125221143chap_e
crape96128443crap_e
culpae10389263culpae
drape85319633drap_e
elapse857523elapse
etape74413703etap_e
frappe13286953frappe
gable85325523_gable
gadje1457743_gadje
gae46457703_g__ae
gaffe124111653_gaffe
gaga66625553_gaga_
gage65936103_ga_ge
gala55635163_gala_
galah95917623_galah
galas65731643_galas
galax135314463_galax
gale56347323_ga_le
galea64722933_galea
galeae74717453galeae
gama77035513_gama_
gamas85431353_gamas
gamay116419103_gamay
gambe106219213_gambe
game76644323_ga_me
gane55145293_ga_ne
gap67055613_gap__
gaped96123533_gaped
gaper86125123_gaper
gapes86030823_gapes
gapped124217123_gapped
gappy136212033_gappy
gaps76042973_gap_s
gapy106320913_gap_y
garage8314513_garage
gate55746573_ga_te
gauge76117903_gauge
gauze155712973_gauze
gavage1137193_gavage
gave84634053_ga_ve
gayal9312713_gayal
gazar154612983_gazar
gaze145032413_ga_ze
grape84824663grap_e
hapax1739323_hapax
japan14411233_japan
jape134923423_jap_e
kapa106021293_kapa_
kapas116021733_kapas
lagnappe1351703lagnappe
lapse74917683_lapse
magpie1139093mag_pie
maple95521143_maple
nagana748943nagana_
naganas847983naganas
napa66927263_napa_
napas75924353_napas
nape65230803_nap_e
nappe96114993_nappe
palapa10310673palapa_
palapas11311493palapas
papa85827143_papa_
papal95820673_papal
papas94927493_papas
papaw125112493_papaw
parae76335703_parae
pupae96515643_pupae
rape65041633_rap_e
raphae114311733_raphae
raphe104916423_raphe
rhaphae1543193rhaphae
rhaphe1433423rhaphe
sagaman10117553sagaman
salpae84614273salpae
sarape84817573sarap_e
scape96921843scap_e
shape105125113shap_e
spae65034323__spae
staple84415823staple
tapa65129143_tapa_
tapas74627713_tapas
tape64538143_tap_e
trapan82412973trapan
vaginae11377683vaginae
watape11208483watap_e

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162047.03016033.6
3Display Results2042040.0633238.1
 (SQL Overall)1786912047.24924650.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.