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

100 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
forestal1141028(None) 
forestall1246911forestall
forestay1448191forestay
forestial1247231forestial
agrestal945652agrestal
borstal939042bor_stal
crestal9312132_crestal
festal94213562f__estal
foetal9311882fo_e_tal
foresail1147822foresail
foresaw1377132fores_aw
forest94926742forest__
forestage1346972forestage
forestalls1345802forestalls
forestays1546622forestays
forested12312462forested
forester11313672forester
forestry1446722forestry
forests104114952forest_s
aortal65217513aor__tal
boreal84817213bore__al
borstals1037473bor_stals
coastal9411043co_astal
cornstalk1543943cornstalk
costal85419513co__stal
crustal939023_crustal
crystal1237433_crystal
dorsal74613943dor_s_al
fenestral1244113fenestral
fetal85623373f__e_tal
fiesta938123f_iesta_
fiestas1038433f_iestas
fontal9313143fo__ntal
footstalk1642983footstalk
footstall1243483footstall
forbidal1444833forbidal
forebay1538133fore_bay
forebear1346383forebear
foredate12310913foredate
forefeel14105513forefeel
forehead1537893forehead
foreman12312363fore_man
forepaw1595613fore_paw
forepeak17134783forepeak
foreplay1645673foreplay
foreran10311793fore_ran
fores85847103fores___
foresaid1247803foresaid
foresails1247153foresails
foresee10414333fores_ee
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
foreshank1944673foreshank
foreshow1785893foreshow
foreside12310303foreside
foreskin1547023foreskin
forespake18105233forespake
forespeak1843473forespeak
forestages1446733forestages
forestalled1553383forestalled
forestaller1453253forestaller
foresters12312543foresters
foresting13311363foresting
forestland1453023forestland
foreswear1543513foreswear
foretell1146123foretell
foretold1256493fore_told
foretop12117893fore_top
forksful1842493forksful
formal113215213for__mal
fornical1347793fornical
foveal1237703fove__al
fractal1237623f_ractal
fresnel1035893f_resnel
fretsaw1343923f_retsaw
frontal1038363f_rontal
frusta937453f_rusta_
homestay1645823homestay
horsetail1244693horsetail
locustal10325223locustal
lodestar944413lodestar
loessal744393lo_essal
loreal63814313lore__al
mortal84616853mor__tal
omental93210423_omental
orbital936923_orbital
oriental848493_oriental
parental10310953parental
pedestal1146403pedestal
podesta1036763podesta_
podestas1146853podestas
polestar1047113polestar
portal84218463por__tal
postal84317533po__stal
rectal84418143__rectal
rental63922033__rental
reseal64819653__reseal
sorest65028003sorest__
vestal94615573__vestal

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.420425454.8
2DLD Change Limit1461621007.86018595.7
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.32621461.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.