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 “rationale” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
rationale94946(None) 
rational8412541rational_
rationales1049311rationales
rationals949941rationals
national8311532national_
nationals948862nationals
rationalise111910542rationalise
rationalize20199752rationalize
rationally1349422rationally
actionable14116213actionable
atingle848253_ati_ngle
atonable1038793_at_onable
atonal6514023_at_onal_
factional1478763factional_
fractional1547133fractional_
fractionate1654263fractionate
gyrational1444743gyrational_
irrational1047213irrational_
irrationals1154733irrationals
matinal9312603mati_nal_
matronal1048113matronal_
motional1058673motional_
nationalise111910483nationalise
nationalize20169023nationalize
nationally1348423nationally
notional849403notional_
optional1047643optional_
optionals1145343optionals
ovational1246853ovational_
patinae95414403pati_na_e
patinate103016313pati_nate
patronage1264823patronage
patronal1048653patronal_
radiale83813523radi__ale
rathole10312053ratho__le
ratine65131823rati_n__e
ratiocinate1352953ratiocinate
ration64226013ration___
rationalised13237723rationalised
rationalises122010373rationalises
rationalism131910233rationalism
rationalist111812123rationalist
rationality1458093rationality
rationalized22198033rationalized
rationalizer21206983rationalizer
rationalizes21199253rationalizes
rationalness1254463rationalness
rationed9410093ration_ed
rationing1039783rationing
rations74123433ration__s
regional9438783regional_
regionals10286413regionals
relational1047713relational_
retinae75517333reti_na_e
retinal75318353reti_nal_
retinals85612963reti_nals
rotational1048093rotational_
stational948513stational_
tractional1248053tractional_

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 Filter1786911486410.440406115.9
2DLD Change Limit148641597.56019661.5
3Display Results59590.0163687.5
 (SQL Overall)178691598.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.