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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
retrieved138509(None) 
reprieved1584861reprieved
retrieve1175691retrieve_
retriever1284211retriever
retrieves1265651retrieves
relieved12438512re_lieved
reprieve1375442reprieve_
reprieves1475112reprieves
retried84419152retri__ed
retrieval1243282retrieval
retrievers1373302retrievers
retrimmed1443672retrimmed
aggrieved1591373aggrieved
believed14427923be_lieved
debriefed1642143debriefed
deprived1546463depri_ved
derived123912763de_ri_ved
grieved1235283__grieved
metrified1547853metrified
petrified1548333petrified
pretrimmed1742633pretrimmed
rebreed104611073rebr_e_ed
received1437983recei_ved
redried93714893redri__ed
redrilled1145353redrilled
redrive112410563redri_ve_
redriven12226153redri_ven
redrives122610393redri_ves
reeved104118713re___eved
refried113513873refri__ed
regreened1145553regreened
regreeted1136173regreeted
regrooved1443253regrooved
reived104518133re__i_ved
relieve105010693re_lieve_
reliever11448683re_liever
relieves114210393re_lieves
relived115114683re_li_ved
reordered1145383reordered
reoriented1145343reoriented
repriced132610543repri_ced
reprieval1442833reprieval
reprinted1289043reprinted
reprised112012203repri_sed
reproved14199473repr_oved
rerigged1136243re_rigged
restricted1348303restricted
restrive11310923restri_ve_
restriven1246233restri_ven
restrives12310663restri_ves
retailed94113963retai_led
retained93016093retai_ned
retargeted1243843retargeted
retied75924983ret_i__ed
retiled84420513ret_i_led
retimed104714653ret_i_med
retinted94414363ret_inted
retinued95210823ret_inued
retired84620143ret_i_red
retiree75019083retire_e_
retirees84611653retire_es
retitled9339553ret_itled
retraced111413023retr_aced
retracked1657453retracked
retracted12410953retracted
retrained10411313retrained
retread849003retr_e_ad
retreaded1137053retreaded
retreated10312613retreated
retries74129073retri__es
retrievals1342623retrievals
retrieving1445293retrieving
retroceded1443473retroceded
retwisted1344893retwisted
reviewed1534823re_viewed
revived144211653re_vi_ved
scrieved14366203_scrieved
shrieved15276073_shrieved
strived114713663_stri_ved
thieved1434973__thieved

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641808.34317816.3
3Display Results80800.0461739.1
 (SQL Overall)178691808.54520911.8
 
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.