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

94 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
gentrices125891(None) 
gentrice1148811gentrice_
gentries91315261gentri_es
agentries1048232agentri_es
entices91616332_ent_ices
entries71523162_entri_es
gantries91413782gantri_es
generics11118792generic_s
gentiles93713522gent_iles
gentrifies1446892gentrifies
rectrices1338872rectrices
sentries81318052sentri_es
tectrices1346252tectrices
ventricles1544522ventricles
agentives1346443agent_ives
benefices1645063benefices
bestrides1237913bestrides
centiles103615813cent_iles
centimes124012613cent_imes
centres93817123centr__es
centric11312393centric__
centrical1348343centrical
centrings12227603centrings
centrioles1245803centrioles
centrisms1348053centrisms
centrists11410233centrists
centuries11311333centuri_es
contrives14311703contrives
dendrites1147933dendrites
denticles1237753dent_icles
dentifrices1751863dentifrices
dentines93418393dent_ines
dextrines1798313dextrines
editrices1245323editrices
enriches1337263_en_riches
enterics10312853_enteric_s
entice81316863_ent_ice_
enticed101411193_ent_iced
enticer91510423_ent_icer
enticers10139093_ent_icers
entires71517783_ent_ires
entrances11310953_entrances
entrees71813773_entr_ees
entwines1148753_entwines
gantlines1039333gantlines
gauntries1046033gauntri_es
genderizes2176003genderizes
generates10312703generates
generatrices1552253generatrices
generic101310753generic__
generical1246983generical
genericness1472903genericness
genetics11128613genetic_s
genies75324943gen__i_es
genitives1346663genitives
genocides1344993genocides
genoises939253gen_oises
genomics1345713genomic_s
genres75515623gen_r__es
gentes75324163gent___es
gentians937563gent_ians
gentile83515293gent_ile_
gentles83714343gent__les
gentrified1545673gentrified
gentrifier1444813gentrifier
gentrifiers1543003gentrifiers
gentrify1544683gentri_fy
henries102718283hen_ri_es
heretrices1546293heretrices
heritrices1555303heritrices
lenticel1066123lent_icel
lenticels1184493lent_icels
matrices12312083_matrices
metrics11312363me_tric_s
oratrices1145833oratrices
pantries101817393pantri_es
peltries10313023peltri_es
penuries10311663penuri_es
prentices131111903prent_ices
reentries9311763reentri_es
reprices122913353re_prices
restricts1138823restricts
restrikes1339413restrikes
restrives12310663restrives
retraces101417263re_traces
retries74129073re_tri_es
sentences11610303sentences
tenorites9311083tenorites
trices84826333___trices
veneries112815023veneri_es
ventricle1444383ventricle
ventricose1552783ventricose
vertices13612273vert_ices
vestries11314043vestri_es

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641947.18620684.8
3Display Results94940.0501880.0
 (SQL Overall)178691947.39224173.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.