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

141 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
rational841254(None) 
national8311531national
rationale949461rationale
rationals949941rationals
atonal6514022_at_onal
factional1478762factional
fractional1547132fractional
gyrational1444742gyrational
irrational1047212irrational
matinal9312602mati_nal
matronal1048112matronal
motional1058672motional
nationals948862nationals
notional849402notional
optional1047642optional
ovational1246852ovational
patronal1048652patronal
ration64226012ration__
rationales1049312rationales
rationally1349422rationally
rationed9410092rationed
rations74123432ration_s
regional9438782regional
relational1047712relational
retinal75318352reti_nal
rotational1048092rotational
stational948512stational
tractional1248052tractional
actinal9312293acti_nal
agonal7410053_a_gonal
ammonal1137023_ammonal
anconal939423_anconal
artisanal983823artisanal
axonal1347653_a_xonal
azonal1568273_a_zonal
baritonal1144673baritonal
basinal9310033basi_nal
binational1246373binational
cantonal1038903cantonal
carinal94318233cari_nal
cathodal14155413cathodal
cation83925503cation__
cationic12310013cationic
cations94524143cation_s
citational1266463citational
coitional1148693coitional
datival1135583dati_val
dictional1268613dictional
emotional1146663emotional
equational1945603equational
erosional946623erosional
evasional1244293evasional
fictional1477803fictional
fraternal1243873fraternal
frictional1546253frictional
fusional1145073fusional
gradational1354473gradational
ideational1146503ideational
irrationals1154733irrationals
kathodal16153403kathodal
kation104315683kation__
kations114013663kation_s
lagoonal943093lagoonal
laminal94113633lami_nal
latina65621143lati_na_
latinas74416463lati_nas
librational1344553librational
locational1246593locational
maternal1047803maternal
migrational1444743migrational
mutational1246513mutational
narrational1145443narrational
nation64322803nation__
nationally1348423nationally
nations74720563nation_s
negational1147153negational
nonrational11109123nonrational
notational1048123notational
nutational1047043nutational
operational1347523operational
optionals1145343optionals
oration71617713oration__
orations81515803oration_s
paginal10269493pagi_nal
passional1146043passional
paternal1038333paternal
patina86022193pati_na_
patinae95414403pati_nae
patinas96318523pati_nas
probational1547083probational
racial83419243raci__al
radial74020393radi__al
radiational1245953radiational
radical103312793radi_cal
radioman1145773radioman
ramona8412413ra_mona_
ramonas9311093ra_monas
ratal55025113rat___al
ratine65131823rati_n_e
ratines75328583rati_nes
rating74938703rati_n_g
ratings84217413rati_ngs
ratio55227583ratio___
rationalise111910543rationalise
rationalism131910233rationalism
rationalist111812123rationalist
rationality1458093rationality
rationalize20199753rationalize
rationing1039783rationing
ratios64922673ratio__s
ratoon64417373ratoon__
ratooned977103ratooned
ratooner887003ratooner
ratoons73815473ratoon_s
ratton64116123ratton__
rattons73815323ratton_s
redactional1454353redactional
reginal84814293regi_nal
regionals10286413regionals
retial64724993reti__al
retina65023383reti_na_
retinae75517333reti_nae
retinals85612963reti_nals
retinas74819353reti_nas
retinol7469693reti_nol
retotal739843ret_otal
rhinal9510193r_hi_nal
ruminal9289993rumi_nal
sectional1149423sectional
subrational1345493subrational
suctional1147683suctional
tonal53724303__t_onal
traditional1255393traditional
tuitional946053tuitional
vaginal11288403vagi_nal
variational1444773variational
vatical1239983vati_cal
vaticinal1444573vaticinal
vibrational1644363vibrational
visional1146663visional
vocational1546953vocational

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.423422437.4
2DLD Change Limit1461621416.90321173.7
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.38924183.4
 
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.