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

142 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
remarry123519(None) 
recarry1245061recarry
marry104821692__marry
remark123512372rema_rk
remarks13329982remarks
berry104521773be__rry
beworry1543743beworry
carry105823783__carry
cedary12419603ceda_ry
charry145012113_charry
creamery15385983creamery
crematory1647213crematory
dearly104615323de_arly
deary95826843de_a_ry
demark134211023dema_rk
demarks14339233demarks
denary105316863dena_ry
derry94721373de__rry
dreary104611673dre_a_ry
early85324123_e_arly
emery104814333_em_ery
empery1348683_empery
ferry116020803fe__rry
gharry13546273_gharry
gramary1355913grama_ry
harry115322953__harry
hearty126313633he_arty
herry114922473he__rry
jerry155016183je__rry
kerry124916093ke__rry
knarry1334613_knarry
leary85927383le_a_ry
marly106925613__marly
marvy135014033__marvy
memory1338803mem_ory
merry104721493__merry
murry105120233__murry
nearby11356053ne_arby
nearly94813733ne_arly
parry105323753__parry
pearly116414843pe_arly
perry105222713pe__rry
primary1437703prima_ry
quarry1837473_quarry
ready94821503re_a_dy
really93315613re_ally
realty92713693re_alty
reamer84325213reamer_
reamers94221083reamers
rear45644553re_a_r_
reared75930013re_ared
rearer64928913re_arer
rearers74323563re_arers
rearm75923573re_a_rm
rearms85114653re_arms
rears54739653re_a_rs
rebar75420193reba_r_
rebars84019833reba_rs
rebury11349213re_bury
rectory123512733rectory
redry94314363re__dry
reearn6612143reea_rn
reearns749103reearns
reentry1038033reentry
refry114412463re__fry
regally1159873regally
regard85215773rega_rd
regards94112563regards
relay84424673rela__y
remade94316983rema_de
remail85017123rema_il
remails94714563remails
remain85919863rema_in
remains94117913remains
remake124016113rema_ke
remaker133813173remaker
remakers143811303remakers
remakes134116173remakes
reman75730153rema__n
remand95618963rema_nd
remands104914883remands
remans84823003rema_ns
remap95418103rema__p
remaps105012873rema_ps
remarked15209243remarked
remarker14178493remarker
remarkers15197283remarkers
remarket142111033remarket
remarque1993553remarque
remarried1244933remarried
remarries1147673remarries
remarrying1643373remarrying
rematch1436193rematch
remate84428683rema_te
remated103522473remated
remates93827113remates
remedy1237873rem_edy
remerge10148923remerge
remora8414593rem_ora
remoras9314073remoras
remorid10311863remorid
remorse9311713remorse
repair84011463repair_
repairs9319973repairs
repark123511713repa_rk
reparks13249513reparks
repay104818453repa__y
resay85320543resa__y
respray1236503respray
retally10413683retally
retard75018933reta_rd
retards85015003retards
retiary1038333retiary
retry84718083re__try
revelry1335693revelry
revery124014213re_very
reward106017643rewa_rd
rewards114813993rewards
rewarm115913493rewa_rm
rewarms12439603rewarms
rivalry1354033rivalry
rosary92810353rosa_ry
rosemary1344433rosema_ry
rotary92411303rota_ry
scarry116311183_scarry
semidry1345203semidry
senary93716073sena_ry
serry84824123se__rry
smarmy13629353_smarmy
smarty115013793_smarty
smeary114110803smea_ry
sparry115111303_sparry
starry94911673_starry
tarry85422513__tarry
teary85124053te_a_ry
terry84721873te__rry
unmerry1245023unmerry
weary115620613we_a_ry
yearly125210273ye_arly
yeomanry1642443yeomanry
zamarra1843793zamarra
zamarro1842883zamarro

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271427.04619021.7
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.53223724.2
 
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.