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

109 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
rawhide1413497(None) 
raphide13138071raphide
rawhided16153071rawhided
rawhides15145541rawhides
awhile1257792_awhile
cowhide1636142cowhide
rachides141511222rachides
raphides14188392raphides
abide86223723_a_bide
aide56045013_a__ide
amide86128493_a_mide
aphid115515393_aphid_
aphides134711203_aphides
aphids125110843_aphids
archine125817053archine
archive154610483archive
aside65122093_a_side
awhirl1264673_awhirl
azide155617173_a_zide
bawtie113812143bawti_e
brawlie12198153brawli_e
carbide126112493carbide
cathode1338993cathode
chide115321023__chide
cowhided1843753cowhided
cowhides1736013cowhides
dawtie103011093dawti_e
dayside1236173dayside
erewhile1473673erewhile
farside1138603farside
gawsie1038463gawsi_e
graphite1447153graphite
hagride1237553hagride
halide103417993ha_lide
hawkie163810093hawki_e
hayride1437323hayride
hide85134653___hide
jawlike21116003jawlike
jawline17137063jawline
kathode1545733kathode
lawine93316463law_ine
lawlike14137073lawlike
machine14313493machine
mashie11315933mashi_e
rabid84520783ra_bid_
rachial122012173rachial
rachis114017653rachi_s
rachises131412413rachises
ragtime1036163ragtime
raid55243083ra__id_
raided85017703ra__ided
raider74318743ra__ider
raids65827523ra__ids
raise54828053ra__ise
rallied83514083rallied
ralline73518413ralline
ramie75027823ra_mi_e
rampike1536603rampike
rancid9513863rancid_
ranid66429333ra_nid_
ranids75118703ra_nids
ranpike1335933ranpike
raphae114311733raph_ae
raphe104916423raph__e
raphia113511263raphi_a
raphias123511083raphias
raphis114014323raphi_s
rapid86422033ra_pid_
rapider1067903ra_pider
rapids94913893ra_pids
rapine85023083ra_pine
rashlike1535793rashlike
rathe85821923rath__e
rathole10312053rathole
raticide1148943raticide
ratine65131823ra_tine
ratite65022423ra_tite
ratlike113912353ratlike
ratline74517803ratline
ravine95522223ra_vine
rawhiding1743113rawhiding
rawin85521473raw_i_n
rawins95617623raw_ins
rawish123012923raw_ish
raylike14269253raylike
rehire95415863r_ehire
reshine102816943reshine
reside74224933r_eside
rewiden1137533rew_iden
rewire95421413rew_ire
rewrite10311143rewrite
rhachides1853663rhachides
ride55945143r___ide
riptide1036893riptide
roadside1044893roadside
sawlike14138443sawlike
tawie84819813taw_i_e
tawpie11339143tawpi_e
unwhite1336813unwhite
uranide82212093ura_nide
vahine123612113va_hine
wahine123813013wa_hine
wayside1435183wayside
whid115418883__whid_
whids125413993__whids
while115418693__while
whine116022813__whine
white114920303__white
wide85235423__w_ide

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271098.32616097.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.79520317.3
 
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.