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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
frontward164257(None) 
frontwards1742341frontwards
froward1436672fro__ward
forward1438293f_o_rward
frontage1296243front_age
frontal1038363front_a_l
frontals1146273front_als
fronted114011273front__ed
fronter103611583front_er_
frontier1147313frontier_
frontiers1254993frontiers
frontman1344303frontma_n
frontpage15102633frontpage
frontpaged17131683frontpaged
frostwork1943493frostwork
ironware1144653iron_ware
moonward1474473moon_ward
onward1039053__on_ward
outward11811403__outward
bloatware1442174bloatware
boatyard1444074_boatyard
boneyard1475324_boneyard
coastward1543554coastward
contrary1347494_contrary
costard104113354_cost_ard
coward12411674_co__ward
crossword1544024crossword
dotard839054_do_t_ard
downward1644444_downward
drunkard1441554drun_kard
eastward1244994_eastward
flancard1443374flan_card
flatware1444894f_latware
fontal9313144f_ont_a_l
footboard1544494footboard
footmark1743834f_ootmark
footpad1343904f_ootpa_d
footwall1444524f_ootwall
footway1635254f_ootwa_y
footways1744874f_ootways
footwear14103374f_ootwear_
footwork1845814f_ootwork
footworn1445164f_ootworn
forewarn14117174f_orewarn
foreword15118964f_oreword
foreyard1546424f_oreyard
forwards1537044f_o_rwards
foulard11257284f_o_ulard
freeboard1545254freeboard
freeware1446174fr_eeware
frenular1144634frenular_
fretboard1543984fretboard
fretwork1845694fr_etwork
frond95316344fron____d
fronded12388864fron__ded
frondeur1242794frondeur_
frondeurs1342574frondeurs
front85029224front____
frontages13116184frontages
frontally1546114frontally
frontcourt1552174frontcourt
frontenis1243424frontenis
frontes104214164front__es
fronting12310444front_ing
frontless1235404frontless
frontlet1147654front_let
frontlets1244234frontlets
frontline1245054frontline
frontlist1246124frontlist
frontmen1344424front_men
fronton1037204front__on
frontons1136504front_ons
frontpages1692644frontpages
fronts94415794front___s
frosted113211874frost__ed
frostier1148164frostier_
frostworks2043044frostworks
frothed14288784fro_t_hed
frother133110154fro_ther_
frothers14279814fro_thers
frottage1245084fro_ttage
frotteur1142504frotteur_
frotteurs1242224frotteurs
frowardly1962304fro__wardly
frowned14348834fro__wned
fruitwood1652104fruitwood
goalward1343494_goalward
graveward1782394graveward
greensward1551734greensward
groupware1551674groupware
homeward1745324_homeward
inward10310334__in_ward
ironbark1443064iron_bark
ironclad1143094ironcla_d
ironwares1244554iron_wares
ironweed1244054iron_weed
ironwood1245184iron_wood
ironwork15125064iron_work
landward1345824_landward
leftward1562734_leftward
leotard846194leo_t_ard
manward1349094_man_ward
moonwards1574204moon_wards
nonwar9159424_non_war_
nonwars10109004_non_wars
nonword1149154_non_word
northward1643254northward
onboard1046504__onboard
onwards1137174__on_wards
outwar91011514__outwar_
outwards1299124__outwards
outwars10912794__outwars
poleward1455944_poleward
poniard1037584_pon_iard
postcard1346524_postcard
postwar1236904_postwar_
prowar114110944pro__war_
rearward1245784_rearward
rereward1246144_rereward
retard75018934_r_et_ard
reward106017644_r__eward
rightward1743474rightward
ritard74812084_r_it_ard
rootworm1344814_rootworm
rotary92411304_ro_t_ary
shoreward1644094shoreward
software1464254_software
southward1653934_southward
stoneware1254294stoneware
sunward1137654_sun_ward
toward10311064_to__ward
untoward1243194__untoward
vanward1456944_van_ward
westward1543824_westward
windward1665514_windward

Search took 12 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 Filter1786911653290.436409841.7
2DLD Change Limit16532913510.75015379.4
3Display Results1351350.0632142.9
 (SQL Overall)17869113511.24915885.1
 
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.