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

207 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
overland12231200(None) 
overhand15229961overhand
overlaid122410381overlaid
overlands13218881overlands
overlend122510101overlend
operand1038002oper_and
overfond1537322overfond
overfund1535812overfund
overglad13116532overgla_d
overhands16227802overhands
overhang15248862overhang
overhard15238792overhard
overkind1637952overkind
overlade12611552overlade
overladed1459222overladed
overlain112112442overlain
overlap12239832overla_p
overlaps13219522overlaps
overlate11716282overlate
overlax17238412overla_x
overlay132410832overla_y
overlays14239692overlays
overlends13237522overlends
overlent112715292overlent
overlewd15216272overlewd
overload12119282overload
overlong1238122overlong
overlord12119182overlord
overloud12117752overloud
overman12311462overman_
overmans13310312overmans
overmany1647142overmany
overpaid14158932overpaid
overplaid1546812overplaid
overplan13258942overplan_
overplans14249572overplans
overplant142510712overplant
overran10311662overran_
overrank1548112overrank
oversad11259962oversa_d
overwind1538532overwind
avellan1037293avellan_
avellane1146263avellane
borderland1452163borderland
coverlid1445943coverl_id
eland65820393__e_land
errand758793__errand
fenland1135693_fenland
foreland1239013fore_land
garland948703_garland
homeland1446233home_land
moorland1144683moorland
motherland1652613motherland
norland837163_norland
operands1146813oper_ands
operant9317223oper_ant
outland81212343o_utland
ovarian1037643ovarian_
overact12315043over_act
overage11514053over_age
overaged13511673overaged
overall10411083over_all
overalled1339073overalled
overalls11410393overalls
overapt12312653over_apt
overarm12239793over_arm
overate10620963over_ate
overawe13511463over_awe
overawed1579973overawed
overbake17129803overbake
overbaked19127833overbaked
overbed132811853over_bed
overbid132710273over_bid
overboard1537813overboard
overbold14208553overbold
overbred1459853overbred
overcall1337673overcall
overcame151310693overcame
overcast132411973overcast
overclaim1645333overclaim
overclass1436963overclass
overclean14115263overclean_
overcleaned1744713overcleaned
overcleans15134883overcleans
overcloud1544743overcloud
overcold14208493overcold
overdare12311183overdare
overdared1439163overdared
overdid12199173over_did
overdone121210913overdone
overdrank1745123overdrank
overdyed16126513overdyed
overeasy1437153overeasy
overeat102620323overea_t
overeats112415263overeats
overed102216623over__ed
overexpand2353143overexpand
overfar13227943overfa_r
overfast14249663overfast
overfat132712283overfa_t
overfed142510253over_fed
overfeed15299443overfeed
overflood1644523overflood
overfrank1944573overfrank
overfunds1644593overfunds
overgild1336583overgild
overgird1336183overgird
overglaze2286273overglaze
overglazed2475413overglazed
overgoad13127153overgoad
overhanded1846693overhanded
overhandle1744123overhandle
overhangs16226553overhangs
overhate14312793overhate
overhated16610443overhated
overhaul1436223overhaul
overhead152110363overhead
overheard16246623overheard
overheld15197373overheld
overhold15219013overhold
overhung15235623overhung
overhunt14208663overhunt
overing111918053over_ing
overlabor1443963overlabor
overladen1367643overladen
overlades13510353overlades
overlading1539323overlading
overlapped1844763overlapped
overlarge1346823overlarge
overlaying1738443overlaying
overleaf14237973overleaf
overleap13237833overleap
overleaped1646303overleaped
overleaps14226783overleaps
overleapt14247883overleapt
overlearn1235903overlearn
overlearned1544453overlearned
overlearns1344993overlearns
overlearnt1346003overlearnt
overlet102619033overl_et
overlets112312363overlets
overlie102615013overl_ie
overlies112417043overlies
overlit102714743overl_it
overlive142211293overlive
overlived16248513overlived
overloaded1566593overloaded
overloads13127663overloads
overlook1596423overlook
overlords13117223overlords
overlove14239173overlove
overloved16217643overloved
overlush1445273overlush
overly122411363overl__y
overlying1638003overlying
overmanned1645713overmanned
overmen12311803overmen_
overmild1436983overmild
overmine13313663overmine
overmined1539603overmined
overpack1966623overpack
overpass13258653overpass
overpast132611023overpast
overpay15228263overpa_y
overpays16248253overpays
overplaids1645433overplaids
overplanned1744343overplanned
overplanted1746233overplanted
overplants15227333overplants
overplay16257553overpla_y
overplayed19206753overplayed
overplays17287013overplays
overplied1539053overplied
overrash1436953overrash
overrate11615693overrate
overrated13313083overrated
overrun1038023overrun_
overruns1138173overruns
oversale11313873oversale
oversalt11312743oversalt
oversave14310493oversave
oversaved1638613oversaved
oversaw13268163oversa_w
overseed122513353overseed
oversold12218933oversold
overspend1545883overspend
overtake151210143overtake
overtalk1537073overtalk
overtame131510523overtame
overtart11312493overtart
overtask1535773overtask
overtax17257733overta_x
overtaxed20117243overtaxed
overtone111012573overtone
overused1249443overused
overwarm16236923overwarm
overwary17197413overwary
overwinds1645573overwinds
overword15119233overword
overwound1644763overwound
reland75920433_re_land
shetland1244633shetland
veranda1156323_ver_anda
verdant11313293_verdant
versant10313833_versant
wetland1135353_wetland
wonderland1552593wonderland

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622077.08020644.4
3Display Results2072070.0762723.7
 (SQL Overall)1786912077.31224438.0
 
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.