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

91 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
homebred1621589(None) 
homebreds17213981homebreds
homebrew18213361homebrew
homered133212711home_red
hombre13309302hom_bre_
hombres14369872hom_bres
homebrews19182782homebrews
hovered143411572hove_red
bombed134113873bom_b_ed
bowered133113043bowe_red
cambered15128993cambered
chambered19145983chambered
cohered133514693cohe_red
combed135516543com_b_ed
compared153811823compared
compeered1646303compeered
compered153414923compered
covered133315293cove_red
cowered133214643cowe_red
cumbered15157953cumbered
dogeared1145793dogeared
dormered1255673dorme_red
dowered122811553dowe_red
fomented1437803fomented
gomerel1036393gome_rel
hammered16218843hammered
hampered16239923hampered
havered144011453have_red
heired103813043h__eired
herbed123513453h__erbed
highbred1843373highbred
hobbed144114303ho__bbed
hobbled153310783ho_bbled
hoboed124511683ho__boed
hollered1237603hollered
homaged1497413hom_aged
homebody1954053homebody
homebound1743593homebound
homeboy1746153homeb_oy
homeboys1845513homeboys
homed115425423hom___ed
homeland1446233homeland
homelier1338983homelier
homemade1645133homemade
homeported1853513homeported
homer105828453home_r__
homeric14312213home_ric
homers114821973home_r_s
homestead1544023homestead
homeward1745323homeward
honeyed1437773hone_yed
honored11310123ho_nored
honoured1236313honoured
hoovered15195413hoovered
hoseyed1436953hose_yed
hotbed123310673ho_tb_ed
hoveled14209293hove_led
hovelled15146843hovelled
hoverer13319823hove_rer
humbled153711813hum_bled
humored1336723hum_ored
humoured1444363humoured
limbered13158113limbered
linebred1144953linebred
lowbred13225363lo_wbred
lowered112711913lowe_red
lumbered13188233lumbered
membered1535903membered
metred95315143__metred
numbered13147143numbered
ombre94111793_om_bre_
ombres103911133_om_bres
omened93711003_ome_ned
outbred10311263_outbred
overbed132811843_overbed
overbred1459843_overbred
overed102216623_ove_red
powered132911643powe_red
purebred1344253purebred
rebred95816353__rebred
rogered939553roge_red
showered1537013showe_red
smeared104510623_smeared
sobered102912433sobe_red
sombre10729473som_bre_
timbered13137383timbered
tombed113812133tom_b_ed
towered112911403towe_red
truebred1142753truebred
umbered121510113_umbered
wombed14419233wom_b_ed

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.1701051123.5
2DLD Change Limit146162918.72016761.7
3Display Results91910.0303033.3
 (SQL Overall)178691918.92020032.6
 
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.