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

158 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
ventrals11291000(None) 
centrals102712031centrals
ventral103612171ventral_
centals94317052cent_als
central93114472central_
dentals83915392dent_als
enthrals11278902_enthrals
entrails8310162_entrails
entraps9109762_entraps
generals9109332generals
neutrals846282neutrals
peytrals1355492peytrals
rentals74017472rent_als
ventails1139822ventails
ventrally1547252ventrally
vestals104612332vest_als
vestral104111012vestral_
antral65719413_antral_
astrals75515243_astrals
australs8359533australs
aventails1244993aventails
bentgrass1242963bentgrass
benthal1247953benthal_
betrays12127823be_trays
cantals93919573cant_als
cantraps12319113cantraps
cental84420963cent_al_
centares102913893centares
centas85020703cent_a_s
centra84113883centra__
centraler1146683centraler
centralest1247143centralest
centralise1269603centralise
centralism1448643centralism
centralist12511063centralist
centrally1448893centrally
centres93817123centr_es
centrums1236913centrums
citrals91111673_citrals
contrails11410543contrails
contras93015623contra_s
controls10311393controls
denials84114133den_ials
dental74319173dent_al_
dentils84115583dent_ils
dentural948083dentural_
dextral1577003dextral_
dextrans1695983dextrans
engrails945383_engrails
engrams1038073_engrams
enrols61213383_en_rols
entails7912823_entails
enteral73516443_enteral_
enthral103410933_enthral_
enthrall11266833_enthrall
enthralls12256133_enthralls
entoils7810733_entoils
entrain7313073_entrain
entrains8312963_entrains
entrant7318873_entrant
entrants8311753_entrants
entrap8710563_entra_p
entreats839773_entreats
entrees71813773_entrees
entries71523163_entries
enwraps1284833_enwraps
estral64716513_estral_
estrays10529403_estrays
eventual1144883eventual_
extras13310223_extra_s
federals1247303federals
ferals94216643fe__rals
fetials103711743fe_tials
fewtrils1443203fewtrils
funerals1146453funerals
general81010933general_
genitals937243genitals
gentians937563gentians
gentries91315263gentries
inthrals11258503_inthrals
kestrels1235813kestrels
lentils73912973lent_ils
lethals1038113le_thals
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
menials94015683men_ials
menorahs1346543menorahs
mental84521603ment_al_
menthols1347033menthols
metals84520883me_t_als
minerals10311373minerals
mistrals101212623mistrals
neutral737923neutral_
pectorals13128153pectorals
pentads1039523pent_ads
pentyls1236523pent_yls
petals84719813pe_t_als
petrale9312623pe_trale
petrales10312983pe_trales
petrels9279373pe_trels
petrols92913083pe_trols
peytral1287503peytral_
peytrels1363373peytrels
renewals1137273renewals
rental63922023rent_al_
restorals978073restorals
retral64419743re_tral_
retrials8510823re_trials
sendals81912263sen_dals
senoras72714953senora_s
sentries81318053sentries
severals1137593severals
tantras73112093tantra_s
tendrils946443tendrils
tertials8510073tertials
tetrads82910193te_trads
tetras63017623te_tra_s
tetryls1034643te_tryls
vandals113211663van_dals
veals84926193ve___als
venal85523213ven__al_
venerable1438483venerable
venerables1544353venerables
venerably1746423venerably
venerate11312903venerate
venerates12312263venerates
venereal1145083venereal_
veneries112815033veneries
venetians1244673venetians
venial94218283ven_ial_
venires103012453venir_es
venograms1545473venograms
ventage11109623vent_age
ventages12119773ventages
ventail10310453vent_ail
venters103717733vent_ers
ventless11249053ventless
ventricle1444383ventricle
ventricles1544523ventricles
vents86125933vent___s
venturers1245523venturers
ventures11311493ventures
venturis1138193venturis
venturous1245583venturous
verbals121910743ve_rbals
verticals1457243verticals
vesperals1443933vesperals
vestal94615573vest_al_
vestas95916683vest_a_s
vestries11314053vestries
vestural1156473vestural_
veterans1148853veterans
victuals1344773victuals
vinals94716483vin__als
vitals94514303v_it_als
yantras10259003yantra_s
yentas94614213yent_a_s

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621587.22020244.0
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.68623248.9
 
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.