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

153 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
froward143667(None) 
forward1438291forward
coward12411672_coward
forwards1537042forwards
frontward1642572frontward
frowardly1962302frowardly
frowned14348832frowned
prowar114110942prowar_
reward106017642_reward
toward10311062_toward
aboard9312613abo_ard
airward1148133airward
award97118043__award
awkward1843183awkward
becoward1644763becoward
bedward1497473bedward
blowhard1743733blowhard
board85523003_bo_ard
boyard125411283_boyard
briard94311293br_iard
broad84817693bro_a_d
browband1643883browband
browed125216393brow_ed
browned134710973browned
browsed134511233browsed
cowards1339613_cowards
crowbar1444273crowbar_
crowbars1544443crowbars
crowd115815623crow__d
crowded14418793crowded
crowed124717303crow_ed
crower114117563crower_
crowers124614903crowers
crowned133912433crowned
dotard839053_dotard
drownd11478313drow_nd
drowned12419903drowned
drowsed12448743drowsed
fard85639063f___ard
farmyard1742833farmyard
feodary1444713feodary
fiord94313343fio__rd
firmware1643963firmware
fjord16477023fjo__rd
flowage1435723flowage
flowed133513763flow_ed
flower124815503flower_
flowered1546013flowered
flowers133413173flowers
flowery16327783flowery
forbad122710503forba_d
forbare122310513forbare
ford86835493f_o__rd
forearm1238703forearm
forewarn14117173forewarn
foreword15118963foreword
foreyard1546423foreyard
forwarded1743943forwarded
forwarder1644133forwarder
forwardly1942753forwardly
forworn13107793forworn
foulard11257283foulard
fowled133914103f_owled
fraud939863fr__aud
freeware1446173freeware
friar85414273fr_iar_
friars93812093fr_iars
friary124010093fr_iary
frocked17439333frocked
frogged13408493frogged
fromage1336753fromage
frond95316343fro__nd
fronded12388863fronded
fronted114011273fronted
frontwards1742343frontwards
frore86218803fro__re
frosted113211873frosted
frothed14288783frothed
frow106425053frow___
frown115415973frow__n
frowner13429683frowner
frowners14377933frowners
frowns126011393frow_ns
frows116623103frow__s
frowst125512073frow_st
frowsted1534313frowsted
frowsts13426103frowsts
frowsty16464983frowsty
frowsy15498273frow_sy
frowzy24485793frow_zy
grower104614933grower_
growers113612723growers
growled12278173growled
hayward1736413hayward
hoard94918313_ho_ard
holard10410573_holard
inward10310333_inward
ironware1144653ironware
jeopard1744113jeopard
jowar155211433_jowar_
jowars16369653_jowars
leeward1135783leeward
leopard1045293leopard
leotard846193leotard
manward1349093manward
moonward1474473moonward
onward1039053_onward
orchard1346933orchard
outward11811403outward
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
proband122710243proband
procarp1346823procarp
prower114218123prower_
prowled13309913prowled
regard85215773_regard
rereward1246143rereward
retard75018933_retard
rewards114813993_rewards
rewarm115913493_rewarm
reword106321413_reword
ritard74812083_ritard
road56332113_ro_a_d
roar46328573_ro_ar_
roared75015393_ro_ared
roars55622243_ro_ars
roband92310723_roband
rosary92810353_rosary
rotary92411303_rotary
rowan85418733_rowa_n
rowans95715343_rowans
rowed94034323_row_ed
rower85430493_rower_
rowers94924573_rowers
seaward1148183seaward
skyward1843863skyward
sowar85821343_sowar_
sowars94318013_sowars
steward1138063steward
sunward1137653sunward
sward94221463__sward
towards1138783_towards
trocar848773trocar_
trocars959043trocars
troland837543troland
trowed104714653trow_ed
untoward1243193untoward
upward12147163_upward
vanward1456943vanward
vaward13498723_vaward
ward86542253___ward
wayward1736053wayward

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271537.01619103.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.48223882.8
 
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.