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

122 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
repetend113622(None) 
repetends1244001repetends
repeated113117442repeate_d
repented112614982repente_d
reprehend1584072reprehend
reputed104613482repute_d
reverend12288852reverend
appetent1248083appetent
breveted1435623brevete_d
deleted93314903delete_d
depend103510923dep__end
depleted12258703deplete_d
deputed114610173depute_d
extend14267523_e_xtend
greeted93111383gre_ete_d
prepotent1349573prepotent
pretend104011013_pretend
rapeseed1144463rapeseed
reacted103015713reacte_d
reascend1145693reascend
rebated103619693rebate_d
reblend1036653re_blend
receded112713043recede_d
recement12315653recement
recited104319103recite_d
redated93120923redate_d
redemand1245923redemand
redescend1394993redescend
reeded84022563re_ede_d
reefed103816583re_efe_d
reeked113717643re_eke_d
reeled74725533re_ele_d
reested82916233reeste_d
reeved104118713re_eve_d
refected142311663refecte_d
refeed104717623refe_e_d
refereed12149693refereed
referenda1343073referenda
referent112813423referent
refuted114313803refute_d
reheated122415003reheate_d
rejected182710113rejecte_d
rekeyed1536163rekeye_d
related83327573relate_d
relend76116453r__elend
relented92614943relente_d
remated103522473remate_d
remelted11310153remelte_d
remend95216553r__emend
reneged92010763renege_d
renested92212953reneste_d
renewed11309993renewe_d
renitent8315333renitent
rented74426593re_nte_d
reopened1138503reopene_d
repand95316063rep__and
repasted112611533repaste_d
repaved133311133repave_d
repealed113211873repealed
repeater102615443repeate_r
repeaters112811983repeaters
repeating122618983repeating
repegged1334883repegged
repelled113111573repelled
repellent1148383repellent
repent84728873rep__ent
repentant1149313repentant
repenter102813863repente_r
repenters112511553repenters
repenting122316553repenting
reperked15177793reperked
repined104918773repine_d
repinned1157473repinned
replated112817513replate_d
replead10399003rep_lead
repled93319773rep_le_d
replete92912983replete__
repletely1443293repletely
repletes102812463replete_s
replied103914443replie_d
reported11312703reporte_d
reposed103616273repose_d
repotted1139283repotted
repped114616723rep_pe_d
reprehends1643283reprehends
represent11410063represent
reptant92817073rep_tant
repugned1235353repugned
repute84716093repute__
reputes94615963repute_s
reputing112412603reputing
reremind1147513reremind
rerented92516163rerente_d
reseated93220263reseate_d
resected112514743resecte_d
reseed74823293rese_e_d
reseen64318413rese_en_
resend75016773r__esend
resented92716963resente_d
resewed113011823resewe_d
resited85122423resite_d
respected1438493respecte_d
respited11410813respite_d
rested74430783re_ste_d
retene69224273r__etene
retested92212533reteste_d
retted74826313re_tte_d
revehent14239083revehent
reveled113917753revele_d
revered112819333revere_d
reverends13266033reverends
reverent112615093reverent
reverted122714713reverte_d
revested122612243reveste_d
revetment1448323revetment
revetted122210943revetted
revoted114314153revote_d
rewetted12228353rewetted
ripened1038203ripene_d
riveted11258573rivete_d
weekend1533393we_ekend
weeted103913793we_ete_d

Search took 10 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.1561145455.1
2DLD Change Limit1461621228.89316435.6
3Display Results1221220.0761605.3
 (SQL Overall)1786911229.12519582.6
 
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.