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

124 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
farrowed154528(None) 
arrowed1148101_arrowed
furrowed1563831furrowed
harrowed1556261harrowed
marrowed1445971marrowed
narrowed1235201narrowed
borrowed1465042borrowed
burrowed1444442burrowed
carromed1338562carromed
fallowed15127752fallowed
farrow12309972farrow__
farrows13259782farrow_s
furrower1464032furrower
garroted1056782garroted
harrower1446362harrower
narrower1145062narrower
parroted1158842parroted
sorrowed1264832sorrowed
allowed111610073_allowed
aproned10311503_aproned
arbored103811603_arbored
armored102610473_armored
arrased8149863_arrased
arrayed11117153_arrayed
arrived11127353_arrived
arrow83414883_arrow__
arrowhead1641793_arrowhead
arrows92813483_arrow_s
arrowy12288273_arrow_y
avowed1335953_a_vowed
barraged1297683barraged
barred95725793barr__ed
barreled1137843barreled
barrow114512763barrow__
barrows123411683barrow_s
borrower1384833borrower
browed125216393__browed
burrower1374263burrower
carboyed1637183carboyed
caroled103717683ca_roled
caromed123713623ca_romed
carried103717153carr_ied
cartoned111312833cartoned
cornrowed1543623cornrowed
corroded12147513corroded
crowed124717293__crowed
escrowed1434653escrowed
factored1436213factored
faggoted1443103faggoted
fagoted1236073fa_goted
faired105915773fair__ed
farced125216533fa_r_ced
farded114518953fa_r_ded
fared95842343fa_r__ed
farmed125117653fa_r_med
farrier103514893farr_ier
farrowing1645873farrowing
farted105121783fa_r_ted
fathomed1744733fathomed
favored1455983fa_vored
fellowed15136833fellowed
ferreled1234833ferreled
ferreted1236323ferreted
ferried113411523ferr_ied
ferruled1263923ferruled
flowed133513763f__lowed
followed15146273followed
forboded15215353forboded
frowned14348833f__rowned
furred104514433furr__ed
furrow12427743furrow__
furrowers1563503furrowers
furrows13327793furrow_s
furrowy16384473furrow_y
garoted9710133ga_roted
garred85217403garr__ed
garreted1057523garreted
garrote8510103garrote_
garroter956573garroter
garrotes969363garrotes
garrotted1164133garrotted
hallowed15179493hallowed
harbored1438633harbored
harried113815533harr_ied
harrow122610773harrow__
harrowers1555683harrowers
harrows132611033harrow_s
jargoned1735233jargoned
jarred144613253jarr__ed
larruped1142863larruped
marooned1138563marooned
marred95421043marr__ed
married104715303marr_ied
marrow112812603marrow__
marrows122911823marrow_s
marrowy15236083marrow_y
mirrored1145773mirrored
narrated9310323narrated
narrow9269143narrow__
narrowest1244283narrowest
narrowly1442903narrowly
narrows10258843narrow_s
outrowed1239433outrowed
pardoned12189333pardoned
paroled104217623pa_roled
parred95024073parr__ed
parried103615723parr_ied
parroket1449203parroket
parroter1058203parroter
rowed94034323___rowed
sallowed12149033sallowed
sorrower1165033sorrower
strowed115312143_strowed
tallowed12157713tallowed
tarred74720283tarr__ed
tarried83914133tarr_ied
trowed104714653__trowed
varoomed1445293varoomed
wallowed15148163wallowed
wardrobed1662523wardrobed
warpower1645043warpower
warred104019843warr__ed
yarrow12287933yarrow__
yarrows13277853yarrow_s

Search took 10 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.203880251.2
2DLD Change Limit1461621249.42015516.1
3Display Results1241240.0462695.7
 (SQL Overall)1786911249.66918480.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.