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

170 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
ruminal928999(None) 
luminal93711001luminal
rumina83412481rumina_
criminal1248302criminal
geminal10109902geminal
laminal94113632laminal
liminal93810672liminal
lumenal9307272lumenal
lumina84613542lumina_
nominal92712372nominal
numina83510842numina_
reginal84814292reginal
retinal75318352retinal
rhinal9510192r_hinal
ruminant1047852ruminant
ruminate10511472ruminate
seminal91213402seminal
urinal6614122_urinal
viminal12288822viminal
actinal9312293actinal
admiral1046363admiral
affinal1336443affinal
albinal937813albinal
alumina9510053alumina_
aluminas1048353aluminas
ammonal1137023ammonal
anginal8310163anginal
audial7312993audi_al
basinal9310033basinal
binal75323823__binal
brumal1049503brum__al
burial84117623buri_al
cacuminal1553473cacuminal
carinal94318233carinal
clinal8311553_clinal
comical13312223comical
criminals1346293criminals
crucial1157893cruci_al
cubical1338463cubical
cubital1137103cubital
cumin94616973cumin__
cumins103314933cumin_s
curial84019153curi_al
domical1239373domical
encinal949243encinal
final83922033__final
foraminal1444263foraminal
fuming124013293fumin_g
fumingly1735743fumingly
fusional1145073fusional
germinal1147253germinal
gremial1039153gremi_al
humeral1238563humeral
humoral1237973humoral
hymenal1545183hymenal
hymnal1434913hym_nal
jumbal1758463jum_bal
juvenal1743393juvenal
lamina84920443lamina_
laminae93512973laminae
laminals10339303laminals
laminar93810283laminar
laminas93615873laminas
limina83514503limina_
luminary13336653luminary
matinal9312603matinal
mimical1339233mimical
mina65136923__mina_
minae75627723__minae
minas75434113__minas
musical1139553musical
nomina83113683nomina_
nominals10278613nominals
noumenal1046173noumenal
numeral939083numeral
ordinal838633ordinal
original956793original
paginal10269493paginal
quinol15357973qu_inol
quintal16389883qu_intal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
ramal74622243ram__al
ramona8412413ramona_
ramonas9311093ramonas
rational8412543rational
recital9412163recital
redial74923113redi_al
regina75317143regina_
reginae84713453reginae
reginas85614063reginas
regional9438783regional
regnal74812933r_egnal
remigial1146603remigial
remind94819793remin_d
reminds104614793reminds
remint85329973remin_t
remints95117293remints
remittal1046513remittal
removal1236733removal
renal55929503r__enal
retial64724993reti_al
retina65023383retina_
retinae75517333retinae
retinals85612963retinals
retinas74819353retinas
retinol7469693retinol
revisal1038263revisal
revival1337033revival
rial45938093r__i_al
riming93322223rimin_g
rival85216503r__ival
riyal84413433r__iyal
rosinol756323rosinol
ruana5312423ru_ana_
ruanas6311263ru_anas
rubrical1296093rubrical
ruderal837373ruderal
rufiyaa1341193rufiyaa
rugal65916093ru__gal
ruin47430513ru_in__
ruinable1039263ru_inable
ruinate7312833ru_inate
ruined74813323ru_ined
ruiner64013643ru_iner
ruing67221053ru_in_g
ruins55822033ru_in_s
ruling73219553rulin_g
rulings83310383rulings
rumba93612513rum_ba_
rumbas102512013rum_bas
rumen74419503rumen__
rumens83611813rumen_s
ruminantly1553263ruminantly
ruminants1144913ruminants
ruminated1258663ruminated
ruminates11410193ruminates
ruminator1166813ruminator
runnel63510663ru_nnel
rupiah1146213rupi_ah
rural55821173ru__ral
rusine63916593rusin_e
rustical1048393rustical
rutin55421343rutin__
rutins63818393rutin_s
semina8915563semina_
seminar979753seminar
somital939403somital
spinal84915313_spinal
staminal1046983staminal
summital1244703summital
tegminal1144453tegminal
terminal1039733terminal
trinal6516963_trinal
tumoral938133tumoral
turbinal1045623turbinal
umbonal1144383_umbonal
umbral1038633_umbral
umiac938963_umi_ac
umiak1137673_umi_ak
umiaq1656823_umi_aq
uncinal959963uncinal
urial54823023_uri_al
urinals7610253_urinals
vaginal11288403vaginal
veinal93812963_veinal
vicinal12268543vicinal
vimina11339943vimina_
vinal85725813__vinal

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271707.09318895.7
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.56223630.1
 
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.