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

111 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
gremials113613(None) 
gremial1039151gremial_
redials84416882_redials
remails94714562_remails
uremias9249502uremia_s
aerials74017553_aerials
anemias92512143anemia_s
arterials949693arterials
bromals1139743brom_als
chemicals1845603chemicals
cremains1238693cremains
creminis12208253creminis
criminals1346303criminals
denials84114133_denials
dreidls934053dre_idls
emails84412343__emails
eremites10312603eremites
fecials123510333_fecials
fetials103711743_fetials
fremitus1344023fremitus
gavials1136603g_avials
geminal10109913g_eminal_
genial74917613g_enial_
genitals937243g_enitals
geranials1045913geranials
gerbils1037303gerbi_ls
germans1079473germ_ans
germinal1147263germinal_
gharials1245123gharials
gimbals12257823g_imbals
gimmals12225823g_immals
gomerals1147443gomerals
graals74112913gr__aals
graduals1046203graduals
grails77518783gr_ai_ls
gramas94317203gram_a_s
grammars13345943grammars
grammas12499773gramma_s
grampas12399253grampa_s
graymails1542803graymails
greats76318393gre__ats
grecizes2035683grecizes
greenmails1382783greenmails
greiges937733gre_iges
gremlins1136053gremlins
gremmies1355993gremmies
greylags1392313greylags
grills74314803gr__ills
grimily1336523grimi_ly
jeremiads1942193jeremiads
medials103914733_medials
menials94015683_menials
prebills1237293prebills
predial103815413predial_
premeal11310523premeal_
premiers122911653premiers
premies113823063premi_es
premises123018273premises
premiss113513813premi_ss
premiums1437533premiums
premixes193110083premixes
pretrials1158143pretrials
prevails1337663prevails
proemial1249183proemial_
pyemias1436803pyemia_s
radials83614643_radials
reals55038653_re__als
rebills93510623_rebills
recitals1039763_recitals
recoals94214623_recoals
redial74923113_redial_
redias74523603_redia_s
refills103711423_refills
remail85017123_remail_
remains94117913_remains
remans84823003_rem_ans
remaps105012873_rem_aps
remiges103015473_remiges
reminds104614793_reminds
remints95117293_remints
remises93423483_remises
remiss84216353_remi_ss
remits85622943_remi_ts
remittals1144883_remittals
remixes164313873_remixes
removals1345643_removals
renails74917263_renails
rentals74017473_rentals
reoils64516873_reoi_ls
repeals94014523_repeals
resails74616743_resails
reseals73917663_reseals
retails74718973_retails
retial64724993_retial_
retinals85612963_retinals
retrials8510823_retrials
reveals103812723_reveals
revisals1136813_revisals
revivals1435433_revivals
rials55026673_r__ials
serials73919743_serials
specials1238033specials
terminals1147463terminals
tertials8510073tertials
trenails869843trenails
trials64319883tr__ials
uraemias1046043uraemia_s
uredial82910483uredial_
uremia82910893uremia__
urials64415193ur__ials
viremias1345873viremia_s

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.420425454.8
2DLD Change Limit1461621117.56319325.9
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.02922255.7
 
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.