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

128 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
genitals93724(None) 
genital849791genital_
centals94317052cen_tals
denials84114132deni_als
dentals83915392den_tals
generals9109332generals
genial74917612geni_al_
genipaps1342162genipaps
genitalia1044022genitalia
genitalic1243922genitalic
genitally13127172genitally
genitors937422genitors
gentians937562gentians
lanitals837722lanitals
menials94015682meni_als
recitals1039762recitals
rentals74017472ren_tals
aerials74017553aeri_als
agential958153agential_
animals94111703_animals
bonitas939453bonita_s
cantals93919573can_tals
capitals12209443capitals
cental84420963cen_tal_
centas85020703cen_ta_s
centrals102712033centrals
decimals1345863decimals
denial74720513deni_al_
dental74319173den_tal_
dentils84115583den_tils
devisals1245613devisals
digitals1045433digitals
entails7912823_en_tails
fecials123510333feci_als
fetials103711743feti_als
finials103210153fini_als
galenicals1352333galenicals
gavials1136603gavi_als
geminal10109893geminal_
general81010933general_
genetics11128613genetics
genets75716663genet__s
genettes938303genettes
genevas1185253geneva_s
genially12129523genially
genically151110173genically
genies75324943geni__es
genipap1243123genipa_p
genips9469943geni__ps
genitival1343293genitival_
genitive1247643genitive
genitives1346663genitives
genitor837273genit_or
geniture946453geniture
genitures1046123genitures
genius74512923geni__us
geniuses935933geniuses
genoas74013623gen_oa_s
gentes75324163gen_t_es
gentian8310103gentia_n
gentil74115123gen_til_
gentile83515293gen_tile
gentiles93713523gentiles
gentle74014513gen_t_le
gentles83714343gen_tles
gently103710913gen_t_ly
gentoos838633gen_toos
gents65729613gen_t__s
geoidal936703geoidal_
geranials1045913gerani_als
gestalt8411163ge_stalt
gestalts955493ge_stalts
getas65421483ge__ta_s
gingals9109303gin_gals
granitas92610223granita_s
gremials1136133gremi_als
guitars8116853g_uitars
gunites8313123gunit_es
gunmetals1242903gunmetals
initials848103_initials
instals7611713_instals
lanital7310913lanital_
lenites7818443lenit_es
lenities8315943lenities
lentils73912973len_tils
medials103914733medi_als
medicals1349363medicals
menial84223033meni_al_
mental84521603men_tal_
metals84520883me__tals
meticals12310763meticals
minimals12327423minimals
orbitals1045713orbitals
penial84120893peni_al_
penicils1247863penicils
pentads1039523pen_tads
pentyls1236523pen_tyls
petals84719813pe__tals
pinitols1046103pinitols
quintals17288003quintals
recital9412163recital_
redials84416883redi_als
refutals1165503refutals
remittals1144883remittals
renewals1137273renewals
rental63922023ren_tal_
requitals1844043requitals
retinals85612963retinals
retotals838463retotals
revisals1136813revisals
revivals1435433revivals
seitans73312303se_itans
sendals81912263sen_dals
serials73919743seri_als
spitals93011593_spitals
tenias64720073teni_a_s
tertials8510073tertials
venial94218283veni_al_
ventails1139823ven_tails
ventrals11299993ventrals
veritas103012753verita_s
vestals104612333ve_stals
vitals94514303__vitals
xenial133414903xeni_al_
xenias133712973xeni_a_s
yentas94614213yen_ta_s
zenithal2093333zenithal_
zeniths1935153zenit_hs

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.1561145455.1
2DLD Change Limit1461621288.12617987.0
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.32821456.7
 
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.