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

151 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
repartee1031275(None) 
departee1139721departee
repartees1147251repartees
departed1238822departed
departees1265722departees
deportee11510352deportee
reparked15208922reparked
repasted112611532repasted
reported11312702reported
reporter10411422reporter
biparted1335133biparted
depart94720563depart__
departs104310683depart_s
departure1243803departure
deported1249703deported
deportees1256643deportees
deporter1169393deporter
ecarte84313503_ecart_e
ecartes94212563_ecartes
hearted113314023he_arted
hearten102411753he_arten
imparted13248063imparted
imparter12357543imparter
legatee82814633lega_tee
pardee93922023__pardee
parted94228683__parted
pattee84323383__pattee
pearter9412743pe_arter
prepare111913623prepar__e
prepared132210873prepar_ed
preparer12169643prepar_er
prepares122014163prepar_es
prepaste12139083prepast_e
prepasted14137673prepasted
prepastes13128823prepastes
ramparted1443543ramparted
rapparee1245873rappar_ee
reacted103015713re_acted
realter73716313re_alter
reared75930013re_ar_ed
rearer64928913re_ar_er
reargue836463re_argue
rearmed103912823re_armed
rebaited11410543rebaited
rebate84424113reba_t_e
rebated103619703reba_ted
rebater93517913reba_ter
rebates95123183reba_tes
recanted112513513recanted
recanter101913153recanter
recarpet12310603recarpet
recharted1557563recharted
recharter1466893recharter
recrate92621663recrat_e
recrated112918603recrated
recrates102420373recrates
redacted12410243redacted
redargue1043663redargue
redate74124683reda_t_e
redated93120923reda_ted
redates83423873reda_tes
reearned948883reearned
refasten1136103refasten
referee101615753refer_ee
regarded11279803regarded
regrate82618663regrat_e
regrated102816333regrated
regrates92618403regrates
reharden1276303reharden
rejectee17289623rejectee
relate64033633rela_t_e
related83327573rela_ted
relater73723143rela_ter
relates73731433rela_tes
remarked15209243remarked
remarker14178493remarker
remarket142111033remarket
remarque1993553remarque
remaster10311473remaster
remate84428683rema_t_e
remated103522473rema_ted
remates93827113rema_tes
repacked17188743repacked
repainted1277863repainted
repaired1148953repaired
repairer1036783repairer
repairmen1343333repairmen
repanel939963repa_nel
repaper11310023repa_per
reparable1359953reparable
reparative1548173reparative
repark123511713repar__k
reparks13249513repar_ks
repassed11229273repassed
repasses101810373repasses
repast83520633repast__
repasts93611933repast_s
repatch1435843repa_tch
repattern1143663repattern
repave114813873repa__ve
repaved133311133repa_ved
repaves123513653repa_ves
repeated113117443repeated
repeater102615443repeater
repented112614983repented
repenter102813863repenter
reperked15177793reperked
rephrase1346733rephrase
replanted1248063replanted
replaster1136583replaster
replate93420053replat_e
replated112817523replated
replates102919273replates
replete92912993replet_e
repletes102812473repletes
report85326023report__
reportage1245023reportage
reporters1139173reporters
reports94916213report_s
repotted1139283repotted
reprice113212833rep_rice
reprieve1375443rep_rieve
reprise92715043rep_rise
reprobe112310133rep_robe
reprove122911073rep_rove
repursue1044033repursue
repute84716093rep_ut_e
reputed104613483rep_uted
reputes94615963rep_utes
resorted9313493resorted
resorter8312183resorter
restarted10410053restarted
retarded102410753retarded
retarder9229433retarder
retarget9312743retarget
retaste72313133retast_e
retasted92412113retasted
retastes82212903retastes
retiree75019083retir_ee
retorted9312333retorted
retorter8410733retorter
returnee8449883returnee
reverted122714713reverted
reverter114812873reverter
rewarded13229523rewarded
rewarder12208233rewarder
rewarmed14257433rewarmed
separate10310783separate
separated1237713separated
separates11310743separates
unparted11310823unparted

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.423422437.4
2DLD Change Limit1461621517.56319325.9
3Display Results1511510.0602516.7
 (SQL Overall)1786911518.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.