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

83 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
adoptee104841(None) 
adopted1136251adopted
adoptees1145121adoptees
adopter1036761adopter
adapted1135842adapted
adapter1036172adapter
adepter1036112adepter
adopt81219742adopt__
adopters1136692adopters
adoptive1445502adoptive
adopts998082adopt_s
abductee1344783abductee
aborted10310423aborted
aborter939933aborter
acceptee14105723acceptee
adapt81218553adapt__
adapters1136103adapters
adaptive1445133adaptive
adaptor1034953adaptor
adapts9107813adapt_s
adept81219643adept__
adeptest1145453adeptest
adeptly1344183adeptly
adepts9117103adept_s
adipose1036653adipose
admittee1145133admittee
adnate72913483adnat_e
adobe84814713ado__be
adobes94411533ado_bes
adoptable1444753adoptable
adopting1237453adopting
adoption1146083adoption
adore65723673ado__re
adored84714243ado_red
adorer74713453ado_rer
adores74420723ado_res
adorned9256893adorned
adorner8246983adorner
adoze155713833ado__ze
adroiter946193adroiter
advisee11147153advisee
allottee887123allottee
amputee1148863amputee
aortae65115473a_ortae
apogee9312563apo_gee
apostle937853apostle
apter76120203a__pter
atopies92816433atopies
auditee8311573auditee
azote144416343azo_t_e
azoted16388593azo_ted
azotes154312223azo_tes
bootee84323023_bootee
coatee84327223_coatee
coopted123710763coopted
copter109822013_copter
diopter1038473diopter
dioptre1055763dioptre
doated84118183_doated
doited85016633_doited
donee66931013_do_nee
donnee74317063_donnee
doolee73018953_doolee
dope76038893_dop__e
doped95326713_dop_ed
doper86128393_dop_er
dopes84935043_dop_es
dopey116020353_dop_ey
dopier93515923_dopier
dote55442883_do_t_e
doted75227073_do_ted
doter65428623_do_ter
dotes65836693_do_tes
dotted84717523_dotted
dottel73610893_dottel
dotter74419343_dotter
dottle74212503_dottle
epopee10312503epop_ee
goatee73219533_goatee
opted84914273__opted
readopted1344913readopted
topee76029953_top_ee
unadopted1344563unadopted

Search took 7 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.406440125.6
2DLD Change Limit134027836.15621771.8
3Display Results83830.0302766.7
 (SQL Overall)178691836.59227107.3
 
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.