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

213 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
reavows133527(None) 
reavow1235721reavow_
avows114910982__avows
meadows1337332meadows
reasons72514942reasons
reavers108320742reavers
reaves94127572reav_es
reavowed1534672reavowed
reflows13258982reflows
reglows11288842reglows
regrows11269152regrows
renvois1036502renvois
replows12329702replows
reshows132510452reshows
resows93915352re_sows
avos77227013__avo_s
avow107816463__avow_
beacons11410733beacons
beanos85516513beano_s
beavers124417323beavers
bellows124313303bellows
belows114614183be_lows
besnows1245153besnows
bestows1248863bestows
bevors111610343be_vors
bravoes12418533bravoes
bravos114711393bravo_s
cahows14399123_cahows
creators102814413creators
deacons10310393deacons
deaves105319533deav_es
devons104512253de_vons
disavows1544043disavows
eaves85231993_eav_es
elbows1196713_elbows
embows1396823_embows
endows104610423_endows
enows85115493_e_nows
envois988703_envois
envoys1255143_envoys
favors124211403_favors
fellows134212433fellows
fervors1336233fervors
flavors1337293flavors
gavots1038113_gavots
greaves113311443greav_es
havocs1435653_havocs
heavens13439303heavens
heavers133717193heavers
heaves124120303heav_es
heavies132713873heavies
jealous1438093jealous
leavens10409303leavens
leavers103717783leavers
leaves94222383leav_es
meadow1237403meadow_
meadowy1644043meadowy
mellows123812233mellows
meows104612683me__ows
miaows1145473mia_ows
nervous1037143nervous
peafowl1543193peafowl
peafowls1642893peafowls
peaveys15324063peaveys
peavies122213403peavies
preavers13910263preavers
preshows16267023preshows
racons84319343r_acons
radons74118533r_adons
ramous8417113r_amous
ratos55528763r_ato_s
ravels94717073r_avels
ravens93916883r_avens
ravers94628183r_avers
raves85441973r_av_es
ravins94622563r_avins
raws75238213r_a__ws
rayons94113343r_ayons
razors154711663r_azors
reaches123423203reaches
reactors103212293reactors
reacts83616603rea_cts
readds84111643rea_dds
readers83823773readers
readies83324713readies
readopt10410843readopt
readopts1146493readopts
readorn8310483readorn
readorns938283readorns
readout8615513readout
readouts938903readouts
reads64835273rea__ds
reagins84215643reagins
reales64934123rea_les
reallots837993reallots
realms84913493rea_lms
reals55038653rea__ls
realtors82811683realtors
reamers94221083reamers
reams75729623rea__ms
reapers93520453reapers
reaps75626193rea__ps
rearers74323563rearers
rearms85114653rea_rms
rearouse839363rearouse
rears54739653rea__rs
reason62616333reaso_n
reatas64021013rea_tas
reavail1035643reavail
reavails1134853reavails
reave84528023reav__e
reaved104523923reav_ed
reaver94524733reav_er
reaving113820533reaving
reavowing1634863reavowing
reawoke14397443reawoke
rebatos92913113rebato_s
rebooks134010513rebooks
reboots93512093reboots
rebops10311433re_bops
rechews1537293rechews
reckons13269653reckons
recons84922993re_cons
recooks134711233recooks
recross989833recross
recrown12257573recrown
recrowns13246143recrowns
rectors93520523rectors
rectos85718783recto_s
redoes74623773re_does
redons75222183re_dons
redos65126763re_do_s
redowa1038453re_dowa
redowas1138393re_dowas
redraws11218473redraws
redtops1037373redtops
reendows12234683reendows
reeves94721493reev_es
reevoke14386363reevoke
reevokes15375993reevokes
reflow12379653reflow_
reflown13316213reflown
regions83613473regions
regloss8218023regloss
reglow10339403reglow_
regrow10309883regrow_
regrown11237363regrown
reivers105117083reivers
reives95723043reiv_es
reknots1136783reknots
relators83316133relators
relooks114010723relooks
removes124514713removes
renews93811753re_news
renown9369983re_nown
renowns10277833re_nowns
renvoi945863renvo_i
repaves123513653repav_es
replots93412633replots
replow114210343replow_
repos74725793re_po_s
repots85621003re_pots
repros84216003repro_s
reroofs1037943reroofs
resaws93713513re_saws
resews94814173re_sews
reshoes102316033reshoes
reshow123111433reshow_
reshown13257903reshown
resods74116303re_sods
resow88217243re_sow_
resown94112923re_sown
respots92912763respots
retools73411023retools
retros63820193retro_s
revamps1433993revamps
revels94220573re_vels
revers94529633re_vers
revets94022173re_vets
reviews1335533reviews
revoke135216243re_voke
revokes144212503re_vokes
revolt9316223re_volt
revolts1038893re_volts
revote94917453re_vote
revotes104716393re_votes
revs75027053re_v__s
revues9813903re_vues
rows75941753r___ows
savors95616103_savors
savoys12427893_savoys
seadogs958643seadogs
seafowl1343913seafowl
seafowls1443663seafowls
seasons72614233seasons
serows96016393se_rows
servos93812723servo_s
shadows1437193shadows
teabowl1244143teabowl
teabowls1343463teabowls
teapots939053teapots
teapoys1235963teapoys
travois1037883travois
treasons848683treasons
vows106626943___vows
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
weavers133714463weavers
weaves123616373weav_es
yellows13329603yellows
zealots1636763zealots
zealous1637813zealous

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272136.28321331.7
3Display Results2132130.0762802.6
 (SQL Overall)1786912136.76526414.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.