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

128 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
ploughed1520430(None) 
plougher14214461plougher
sloughed13305581sloughed
boughed143810262_boughed
coughed143310902_coughed
laughed1235892_laughed
plough12577562plough__
ploughers15193922ploughers
ploughs13526102plough_s
plugged12408032pl_ugged
pouched153612772p_ouched
roughed124210942_roughed
slouched14206742slouched
soughed123811622_soughed
toughed123511692_toughed
avouched1743583avouched
blotched1635653blotched
bloused104310643blou_sed
blushed134411753bl_ushed
claughted1643243claughted
clogged12528653clo_gged
clothed134010283clo_thed
clouded11348833clou_ded
clough12539133clough__
cloughs13517053clough_s
cloured103111543clou_red
clouted104212163clou_ted
couched154115793_couched
cougher133711733_cougher
crouched16359143crouched
douched144012113_douched
eloigned1043423eloigned
flogged13528803flo_gged
flounced1433803flounced
floured11289873flou_red
flouted113210813flou_ted
flushed143310973fl_ushed
furloughed1851273furloughed
glouted9429713glou_ted
glugged11396613gl_ugged
gouged96214593_goug_ed
grouched15356663grouched
kluged12427213kl_ug_ed
laugher1136603_laugher
loathed11419443_loathed
lodged913815703_lodg_ed
logged96622943_lo_gged
longed87121373_long_ed
longhead1345083_longhead
louche115212663_louche_
lough95118483_lough__
loughs105014773_lough_s
lounged9468243_lounged
louped95316383_lou_ped
loured74617403_lou_red
loused74822913_lou_sed
louted74920693_lou_ted
louvred11354663_louvred
luged74019093_l_ug_ed
lugged94417053_l_ugged
lushed104218723_l_ushed
mouched153612593_mouched
mouthed133811043_mouthed
ouched124316933__ouched
oughted1236223__oughted
plagued11307473pl_agued
plashed133712643pl_ashed
pleached16338063pleached
pledged12358613pledg_ed
plighted1546463pl_ighted
plodded1265563plo_dded
plonked14348103plo_nked
plopped11288773plo_pped
plotted104612373plo_tted
plotzed19376213plo_tzed
ploughing16203673ploughing
plowed124213203plo__wed
plowhead1742803plo_whead
ployed124310563plo__yed
plucked16367963pl_ucked
plugger11378423pl_ugger
plumbed14317273pl_umbed
plumed114412883pl_u_med
plumped14318643pl_umped
plunged11439513pl_unged
plunked14429593pl_unked
plusher124010383pl_usher
plushes124313673pl_ushes
poached154212403p_oached
polished1468433polished
ponged105619353p_ong_ed
pooched152810083p_ooched
poohed123912523p_o_ohed
pouches144116743p_ouches
poufed12449713p_ou_fed
pouffed16365953p_ouffed
pounced123510623p_ounced
pounded114112793p_ounded
poured95116743p_ou_red
pouted94021393p_ou_ted
progged12409793pro_gged
pronged113912393prong_ed
pugged114314523p__ugged
pushed125017463p__ushed
rouged86717323_roug_ed
roughen11338833_roughen
rougher113511033_rougher
sleighed1334033sleighed
sleuthed1233813sleuthed
slogged104910463slo_gged
sloshed11329823slo_shed
sloucher13206813sloucher
slouches13208073slouches
slough10539233slough__
sloughier1343673sloughier
sloughs11497563slough_s
sloughy14535803slough_y
slugged104410373sl_ugged
slushed113611243sl_ushed
southed114313993_southed
splodged1333263splodg_ed
sploshed1434323splo_shed
splotched1742823splotched
sughed113610203__sughed
touched134914963_touched
toughen11329203_toughen
tougher114210983_tougher
vouched163910563_vouched

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.1561145455.1
2DLD Change Limit1461621288.39017421.0
3Display Results1281280.0931376.3
 (SQL Overall)1786911288.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.