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

110 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
redriven1222615(None) 
redrive112410561redrive_
redrives122610391redrives
bedrivel1444082bedrivel
codriven1444392codriven
driven105210142__driven
redried93714892redri_ed
redries83721712redri_es
redriving1437602redriving
redrove11249422redrove_
regiven11478322re_given
rerisen73613642re_risen
restriven1246232restriven
bedizen1935943bed_izen
bedridden1441683bedridden
bedrivels1542713bedrivels
codrive1337643codrive_
codriver1435903codriver
codrives1437663codrives
deprive1338303deprive_
deprived1546463deprived
depriver1446293depriver
deprives1438393deprives
derive103817043de_rive_
derived123912763de_rived
deriver114213913de_river
derives114017813de_rives
drive95318003__drive_
drivel105110383__drivel
driver104714493__driver
drives105117113__drives
enliven1034903_enliven
misdriven1544073misdriven
outdriven1344313outdriven
overdriven1744733overdriven
predive13511083pred_ive_
predried12309573predri_ed
predries112714383predri_es
receive1239733receive_
received1437983received
receiver1337413receiver
receives1339743receives
redden83613613red__den
redeliver1344363redeliver
redfin10310223redfi__n
rediae74221993red_iae_
redline84218833redline_
redlined103811233redlined
redliner93510473redliner
redlines93916083redlines
redrawer1235313redrawer
redrawn11245953redr_awn
redrew10309503redr__ew
redrill857893redri_ll
redrilled1145353redrilled
redrills956083redrills
refried113513873refri_ed
refries104419733refri_es
refrozen2063873refrozen
regimen104411573re_gimen
regive104814323re_give_
regives115014213re_gives
regreen8309043regr_een
reive85522943re__ive_
reived104518133re__ived
reiver95318293re__iver
reives95723043re__ives
relive95120783re_live_
relived115114683re_lived
relives104619443re_lives
reorient8613473reori_ent
reprice113212833reprice_
repriced132610543repriced
reprices122913353reprices
reprieve1375443reprieve
reprieved1584863reprieved
reprieves1475113reprieves
reprise92715043reprise_
reprised112012203reprised
reprises102615463reprises
reprove122911073reprove_
reproved14199473reproved
reprover13229203reprover
reproves132011473reproves
rerise64325633re_rise_
rerises73525883re_rises
reshaven1435193reshaven
restive10315933restive_
restrive11310923restrive_
restrives12310663restrives
retried84419153retri_ed
retries74129073retri_es
retrieve1175693retrieve
retrieved1385093retrieved
retriever1284213retriever
retrieves1265653retrieves
revive124914823re_vive_
revived144211653re_vived
reviver134411373re_viver
revives134715543re_vives
rewiden1137533re_widen
rewoven13557933re_woven
rewrite10311143rewrite_
rewriter1137923rewriter
rewrites11311053rewrites
rewritten1243343rewritten
riven85121623___riven
shriven13379653_shriven
striven103910753_striven
thriven13447023_thriven

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.1731032896.0
2DLD Change Limit1461621108.54617103.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.76520386.9
 
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.