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 “rapine” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
rapine8502308(None) 
rapines95120861rapines
raping94829851raping
rapini84714681rapini
ratine65131821ratine
ravine95522221ravine
repine85627811repine
aline57243162_aline
alpine84417372alpine
amine75835382_amine
aping87327232_aping
arsine64021052arsine
azine146721412_azine
canine83826702canine
caprine11314232caprine
craping124018712craping
daphne12237012daphne
draping114213352draping
elapine9310672elapine
famine114318192famine
gamine94620152gamine
gaping105618922gaping
gradine93317032gradine
grapline1138722grapline
gratine84719192gratine
japing165013572japing
lapin75222922lapin_
lapins84520682lapins
larine63927052larine
lawine93316462lawine
lupine84013532lupine
maline84529102maline
marine84230422marine
narine63422562narine
opine77422462_opine
orpine83914482orpine
patine85328122patine
pine67755722__pine
praline93019752praline
propine113020212propine
racing95030532racing
raging85126432raging
rain46251732ra_in_
rained75024602ra_ined
rains55140232ra_ins
rainy85921082ra_iny
raise54828052ra_ise
raking114728422raking
ralline73518422ralline
ramie75027822rami_e
rampike1536602rampike
ramping123316872ramping
ranpike1335932ranpike
rape65041632rap__e
raphae114311732raphae
raphe104916422rap_he
raphide13138072raphide
rapid86422032rapi_d
rapider1067902rapider
rapids94913892rapids
rapier84019992rapier
rapist82520672rapist
rappee103618672rappee
rappen103512712rappen
rapping123619102rapping
rappini11347572rappini
raring74332872raring
rasing74330832rasing
rasping104316252rasping
ratines75328582ratines
rating74938702rating
ratite65022422ratite
ratline74517812ratline
ravin85624652ravin_
ravined115411822ravined
ravines104220232ravines
raving105128852raving
ravins94622562ravins
rawin85521472rawin_
rawins95617622rawins
raxing144321022raxing
raying105027192raying
razing164524542razing
reaping103621212reaping
refine95225692refine
reline65434352reline
repin75324702repin_
repined104918772repined
repiner94816902repiner
repines94927382repines
repins84924312repins
retine66237332retine
rexine134719442rexine
riping93821612riping
roping94023022roping
rusine63916592rusine
sabine84020392sabine
saline65132712saline
savine94220282savine
spine76534422_spine
supine84216692supine
taping94222392taping
trapline10411862trapline
tropine93116652tropine
vahine123612112vahine
valine94623102valine
wahine123813012wahine

Search took 5 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 Filter178691825510.343520965.0
2DLD Change Limit825511073.94020952.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911074.32941277.7
 
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.