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

197 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
rationed941009(None) 
ratooned977101ratooned
atoned75417542_at_oned
bastioned1246862bastioned
captioned1445762captioned
cautioned1245362cautioned
fractioned1644612fractioned
motioned1137452motioned
optioned1146382optioned
patined105114782pati_ned
radioed939672radio_ed
rained75024602ra_i_ned
ratified12310502ratified
ratine65131822rati_ne_
ratines75328582rati_nes
ration64226012ration__
rational8412542rational
rations74123432ration_s
ratooner887002ratooner
rattened9218622rattened
rattooned1043842rattooned
ravined115411822ravi_ned
rawboned14114252rawboned
stationed1046142stationed
actioner1048663actioner
aliened81011743_aliened
aligned9128553_aligned
alined75221403_ali_ned
aproned10311503_aproned
articled1137063articled
atone56527983_at_one_
atoner64817193_at_oner
atones65225773_at_ones
attorned955363_attorned
attuned835173_attuned
auctioned1244953auctioned
basined10310003basi_ned
batiked1435963bati_ked
battened11259573battened
brained103816103bra_i_ned
buttoned1137503buttoned
cabined1239993cabi_ned
cairned1037643ca_irned
cannoned11118143cannoned
cantoned111411523cantoned
cartoned111312833cartoned
cartooned1246313cartooned
cation83925503cation__
cationic12310013cationic
cations94524143cation_s
cautioner1145393cautioner
clarioned1245733clarioned
cottoned1138033cottoned
crayoned1435003cra_yoned
dragooned1242963dragooned
drained93713253dra_i_ned
fashioned16114463fashioned
fathomed1744733fathomed
fatigued1342943fatigued
fattened12268283fattened
gained84617463ga_i_ned
gammoned1444993gammoned
grained93814273gra_i_ned
gratified1446253gratified
gratine84719193grati_ne_
gratinee93710783grati_nee
gratineed11334473gratineed
hamboned1637003hamboned
intoned8811993int_oned
jargoned1735233jargoned
jawboned21133553jawboned
kation104315683kation__
kations114013663kation_s
latened8711923lat_ened
lesioned936903lesioned
maligned1285773maligned
marooned1138563marooned
masoned1039803ma_soned
matinee92415613mati_nee
mentioned1246833mentioned
motioner1037593motioner
mutined103311353muti_ned
nation64322803nation__
national8311533national
nations74720563nation_s
optionee1046513optionee
oration71617713oration__
orations81515803oration_s
pained95622853pa_i_ned
pardoned12189333pardoned
patinaed11407833patinaed
patine85328123pati_ne_
patines95225773pati_nes
pattened11299393pattened
petioled1137993petioled
pinioned1137513pinioned
platooned1244403platooned
portioned1248343portioned
radiated102512593radiated
radiomen1146633radiomen
raided85017703ra_i_ded
railed74727543ra_i_led
raised76120333ra_i_sed
ramified1438043ramified
rancored1137233rancored
ransomed1146933ransomed
rapiered1136053rapiered
rapine85023083rapi_ne_
rapines95120863rapi_nes
rarified1239053rarified
rated65441383rat___ed
rathole10312053rathole_
ratholes11312413ratholes
raticide1148943raticide
ratifier1139673ratifier
ratifies11313513ratifies
rating74938703rati_n_g
ratings84217413rati_ngs
ratio55227583ratio___
rationale949463rationale
rationales1049313rationales
rationals949943rationals
rationing1039783rationing
ratios64922673ratio__s
ratite65022423rati_te_
ratites74920683rati_tes
ratline74517803ratline_
ratlines83815293ratlines
ratoon64417373ratoon__
ratooners965843ratooners
ratoons73815473ratoon_s
ratted74923343rat__ted
rattener8238533rattener
rattled84012953rat_tled
ratton64116123ratton__
rattons73815323ratton_s
ravened115012283ra_vened
ravine95522223ravi_ne_
ravines104220233ravi_nes
ravished1555713ravished
razored1736333ra_zored
realigned1145333realigned
reasoned9410733reasoned
recautioned1483183recautioned
reckoned1546963reckoned
recoined113614433recoined
refined114720003refi_ned
reigned949213r_eigned
reined74425523r_ei_ned
rejoined16318593rejoined
relined85321933reli_ned
repined104918773repi_ned
repinned1157473repinned
resigned1038863resigned
resined84522653resi_ned
restationed1244373restationed
retained93016093retained
retied75924983reti__ed
retiled84420513reti_led
retimed104714653reti_med
retine66237333reti_ne_
retines75134673reti_nes
retinoid947353retinoid
retinted94414363retinted
retinued95210823retinued
retired84620143reti_red
retitled9339553retitled
retooled938473retooled
retuned86613973ret_uned
returned9459133returned
rezoned173611163r_ezoned
ribboned1343973ribboned
rioted73416373r__ioted
rosined84911913rosi_ned
ruined74813323r_ui_ned
sained75424243sa_i_ned
sanctioned1343903sanctioned
satiated9311603satiated
satinet7325283sati_net
sectioned1246523sectioned
stained84215343stai_ned
stationer946033stationer
stoned75923143_st_oned
suctioned1245283suctioned
taloned8310223ta_loned
tamponed1336023tamponed
tattooed944573tattooed
tined65434533__ti_ned
tinned74317533__tinned
toned65435343__t_oned
trained84117203tra_i_ned
unatoned939423unat_oned
vacationed1643423vacationed
visioned1247013visioned
waggoned1443253waggoned
wagoned1256223wa_goned
wantoned12117223wantoned

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.453394461.4
2DLD Change Limit1461621977.25020160.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.77922970.9
 
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.