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

101 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
reentries931176(None) 
agentries1048232agentries
entries71523162__entries
gentries91315262_gentries
greeneries1167072greeneries
retries74129072r_e_tries
sentries81318052_sentries
beaneries11310903beaneries
carpentries1544793carpentries
centres93817123_centr_es
centuries11311333_centuries
chantries14310293chantries
countries11313613countries
deaneries10310833deaneries
decenaries1348123decenaries
decentres12238523decentr_es
entires71517783__entires
entrees71813773__entrees
errantries1044943errantries
ferneries1239043ferneries
gantries91413783_gantries
gauntries1046033gauntries
gentrices1258913_gentrices
greenbrier1352853greenbrier
greenbriers1452263greenbriers
greenflies1443583greenflies
greenies9312673green__ies
helotries1269563helotries
henneries1248643henneries
henries102718283_hen_ries
legendries1243823legendries
lienteries1047563lienteries
mesenteries1345893mesenteries
misentries1247823misentries
nonentries1048283nonentries
pantries101817393_pantries
pedantries1345683pedantries
peeries93623023pee__ries
peltries10313023_peltries
penuries10311663_penuries
plenaries11410383plenaries
plenties10314693plent_ies
poetries10315583poe_tries
realties8514853realt_ies
reburies10311143r_eburies
recarries1147863recarries
recencies13312253recen_cies
rectories11314643rectories
rectrices1338873r_ectrices
redenies9615713reden__ies
redries83721713r_e_dries
reedifies1347323reedifies
reemerges1255173reemerges
reenergizes2152803reenergizes
reenforces1543493reenforces
reengages1145343reengages
reengraves1444023reengraves
reenlarges1143123reenlarges
reenter73217793reent__er
reentered1038573reentered
reentering1149983reentering
reenters82915303reent_ers
reenthrones1453603reenthrones
reentrances1345173reentrances
reentrant947833reentrant
reentrants1044663reentrants
reentry1038033reentr__y
refectories1646423refectories
refineries1347063refineries
refries104419733r_e_fries
regencies1249283regen_cies
registries1146493registries
reinjuries1743903reinjuries
remarries1147673remarries
rentes65431193r_ent__es
rentier73618223r_ent_ier
rentiers83311763r_ent_iers
repertories1355833repertories
restrikes1339413r_estrikes
restrives12310663r_estrives
reties65436193r_e_t_ies
retires74726213r_e_tires
retried84419153r_e_tried
retrims93612373r_e_trims
reunifies1247583reunifies
revelries1246923revelries
reveries112518513r_everies
robotries1147323robotries
sceneries1149393sceneries
seventies1249673sevent_ies
subentries1246423subentries
teentsier942413teentsier
teentsiest1042983teentsiest
tenantries1045673tenantries
ternaries9311643ternaries
truantries1044023truantries
twenties1137503twent_ies
veeries102916893vee__ries
veneries112815033_veneries
vestries11314053_vestries
weenies102915093ween__ies

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.420425454.8
2DLD Change Limit1486411017.64019455.6
3Display Results1011010.0502020.0
 (SQL Overall)1786911018.11022033.4
 
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.