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 “forewarn” 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
forewarn1411717(None) 
forewarns1585631forewarns
foreworn14108861foreworn
forearm1238702fore_arm
foreman12312362forema_n
forepart1349702forepart
foreran10311792forera_n
foresworn15126072foresworn
forewarned1743582forewarned
foreword15118962foreword
foreyard1546422foreyard
forsworn14125762forsworn
forward1438292for_ward
forworn13107792for_worn
prewarn124410152_prewarn
careworn1347883careworn
cordwain1444413cordwain
firearm1237203fire_arm
fireman1249333firema_n
firepan1236983firepa_n
firewall14125933firewall
firework1847413firework
fireworm1646693fireworm
firmware1643963firmware
foeman11311233fo_ema_n
footworn1445163footworn
forbare122310513for_bare
forbear1237523forbear_
forbears1337073forbears
forearms1336603fore_arms
forebay1538133foreba_y
forebays1637263forebays
forebear1346383forebear_
forebears1446413forebears
forebrain1445163forebrain
forecast1349763forecast
foredate12310913foredate
foreface1647113foreface
forehand1537693forehand
foreign1136833fore_ign
forelady1545073forelady
foreland1239013foreland
foremast1348613foremast
foremen12412923fore_men
forename1347853forename
forenoon1146823forenoon
foreparts1445223foreparts
forepast1348043forepast
forepaw1595613forepa_w
forepaws1695753forepaws
forerank1546753forerank
forerun1037653fore_run
foresaid1247803foresaid
foresail1147823foresail
foresaw1377133foresa_w
foreseen1139103foreseen
foreskin1547023foreskin
forestry1446723forestry
foreswear1543513foreswear_
foreswears1643223foreswears
foreswore15117403foreswore
forever1338953forever_
forevers1438173forevers
forewarning1842783forewarning
forewent1439423forewent
forewing1539003forewing
forewoman1744933forewoman
forewomen1746463forewomen
forewords16117403forewords
foreyards1645503foreyards
forlorn1096423for_lorn
formwork2044533formwork
forswear1443293forswear_
forswears1543243forswears
forswore14106963forswore
forwards1537043for_wards
freeware1446173freeware
froward1436673f_roward
homeward1745323homeward
poleward1455943poleward
prewar114712583_prewar_
prewarm14479613_prewarm
prewarns13456943_prewarns
preworn124711223_preworn
reearn6612143__reearn
rereward1246143rereward
rewan85623663__rewa_n
reward106017643__reward
rewarm115913493__rewarm
reworn98122203__reworn
shoreward1644093shoreward

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.423422437.4
2DLD Change Limit146162917.70318974.7
3Display Results91910.0303033.3
 (SQL Overall)178691918.15621909.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.